Some Important Oracle HRMS Queries

 ----------------------------------------------------------------------------------------
      --- Cursor to check whether a person SSN already exists in the oracle or not
      ----------------------------------------------------------------------------------------
      CURSOR cur_per_ssn (
         p_national_identifier    per_all_people_f.national_identifier%TYPE,
         p_biz_id                 NUMBER)
      IS
         SELECT national_identifier
           FROM apps.per_all_people_f papf
          WHERE papf.national_identifier = p_national_identifier