eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PER_SHD

Line 3687: (NVL(per_per_shd.g_old_rec.effective_start_date,hr_api.g_date)

3683: --
3684: -- check to see if the person fields have been changed
3685: --
3686: IF p_person_update_allowed='TRUE' AND
3687: (NVL(per_per_shd.g_old_rec.effective_start_date,hr_api.g_date)
3688: <>NVL(l_per_effective_start_date,hr_api.g_date)
3689: OR NVL(per_per_shd.g_old_rec.effective_end_date,hr_api.g_date)
3690: <>NVL(l_per_effective_end_date,hr_api.g_date)
3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)

Line 3689: OR NVL(per_per_shd.g_old_rec.effective_end_date,hr_api.g_date)

3685: --
3686: IF p_person_update_allowed='TRUE' AND
3687: (NVL(per_per_shd.g_old_rec.effective_start_date,hr_api.g_date)
3688: <>NVL(l_per_effective_start_date,hr_api.g_date)
3689: OR NVL(per_per_shd.g_old_rec.effective_end_date,hr_api.g_date)
3690: <>NVL(l_per_effective_end_date,hr_api.g_date)
3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)
3692: <>NVL(p_person_type_id,hr_api.g_number)
3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)

Line 3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)

3687: (NVL(per_per_shd.g_old_rec.effective_start_date,hr_api.g_date)
3688: <>NVL(l_per_effective_start_date,hr_api.g_date)
3689: OR NVL(per_per_shd.g_old_rec.effective_end_date,hr_api.g_date)
3690: <>NVL(l_per_effective_end_date,hr_api.g_date)
3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)
3692: <>NVL(p_person_type_id,hr_api.g_number)
3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)
3694: <>NVL(p_last_name,hr_api.g_varchar2)
3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)

Line 3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)

3689: OR NVL(per_per_shd.g_old_rec.effective_end_date,hr_api.g_date)
3690: <>NVL(l_per_effective_end_date,hr_api.g_date)
3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)
3692: <>NVL(p_person_type_id,hr_api.g_number)
3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)
3694: <>NVL(p_last_name,hr_api.g_varchar2)
3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)
3696: <>NVL(p_start_date,hr_api.g_date)
3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)

Line 3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)

3691: AND NVL(per_per_shd.g_old_rec.person_type_id,hr_api.g_number)
3692: <>NVL(p_person_type_id,hr_api.g_number)
3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)
3694: <>NVL(p_last_name,hr_api.g_varchar2)
3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)
3696: <>NVL(p_start_date,hr_api.g_date)
3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)
3698: <>NVL(p_applicant_number,hr_api.g_varchar2)
3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)

Line 3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)

3693: OR NVL(per_per_shd.g_old_rec.last_name,hr_api.g_varchar2)
3694: <>NVL(p_last_name,hr_api.g_varchar2)
3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)
3696: <>NVL(p_start_date,hr_api.g_date)
3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)
3698: <>NVL(p_applicant_number,hr_api.g_varchar2)
3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)
3700: <>NVL(p_background_check_status,hr_api.g_varchar2)
3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)

Line 3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)

3695: OR NVL(per_per_shd.g_old_rec.start_date,hr_api.g_date)
3696: <>NVL(p_start_date,hr_api.g_date)
3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)
3698: <>NVL(p_applicant_number,hr_api.g_varchar2)
3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)
3700: <>NVL(p_background_check_status,hr_api.g_varchar2)
3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)
3702: <>NVL(p_background_date_check,hr_api.g_date)
3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)

Line 3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)

3697: OR NVL(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2)
3698: <>NVL(p_applicant_number,hr_api.g_varchar2)
3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)
3700: <>NVL(p_background_check_status,hr_api.g_varchar2)
3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)
3702: <>NVL(p_background_date_check,hr_api.g_date)
3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)
3704: <>NVL(p_blood_type,hr_api.g_varchar2)
3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)

Line 3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)

3699: OR NVL(per_per_shd.g_old_rec.background_check_status,hr_api.g_varchar2)
3700: <>NVL(p_background_check_status,hr_api.g_varchar2)
3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)
3702: <>NVL(p_background_date_check,hr_api.g_date)
3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)
3704: <>NVL(p_blood_type,hr_api.g_varchar2)
3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)
3706: <>NVL(p_correspondence_language,hr_api.g_varchar2)
3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)

Line 3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)

3701: OR NVL(per_per_shd.g_old_rec.background_date_check,hr_api.g_date)
3702: <>NVL(p_background_date_check,hr_api.g_date)
3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)
3704: <>NVL(p_blood_type,hr_api.g_varchar2)
3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)
3706: <>NVL(p_correspondence_language,hr_api.g_varchar2)
3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)
3708: <>NVL(p_current_applicant_flag,hr_api.g_varchar2)
3709: OR NVL(per_per_shd.g_old_rec.current_emp_or_apl_flag,hr_api.g_varchar2)

Line 3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)

3703: OR NVL(per_per_shd.g_old_rec.blood_type,hr_api.g_varchar2)
3704: <>NVL(p_blood_type,hr_api.g_varchar2)
3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)
3706: <>NVL(p_correspondence_language,hr_api.g_varchar2)
3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)
3708: <>NVL(p_current_applicant_flag,hr_api.g_varchar2)
3709: OR NVL(per_per_shd.g_old_rec.current_emp_or_apl_flag,hr_api.g_varchar2)
3710: <>NVL(p_current_emp_or_apl_flag,hr_api.g_varchar2)
3711: OR NVL(per_per_shd.g_old_rec.current_employee_flag,hr_api.g_varchar2)

Line 3709: OR NVL(per_per_shd.g_old_rec.current_emp_or_apl_flag,hr_api.g_varchar2)

3705: OR NVL(per_per_shd.g_old_rec.correspondence_language,hr_api.g_varchar2)
3706: <>NVL(p_correspondence_language,hr_api.g_varchar2)
3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)
3708: <>NVL(p_current_applicant_flag,hr_api.g_varchar2)
3709: OR NVL(per_per_shd.g_old_rec.current_emp_or_apl_flag,hr_api.g_varchar2)
3710: <>NVL(p_current_emp_or_apl_flag,hr_api.g_varchar2)
3711: OR NVL(per_per_shd.g_old_rec.current_employee_flag,hr_api.g_varchar2)
3712: <>NVL(p_current_employee_flag,hr_api.g_varchar2)
3713: --CWK

Line 3711: OR NVL(per_per_shd.g_old_rec.current_employee_flag,hr_api.g_varchar2)

3707: OR NVL(per_per_shd.g_old_rec.current_applicant_flag,hr_api.g_varchar2)
3708: <>NVL(p_current_applicant_flag,hr_api.g_varchar2)
3709: OR NVL(per_per_shd.g_old_rec.current_emp_or_apl_flag,hr_api.g_varchar2)
3710: <>NVL(p_current_emp_or_apl_flag,hr_api.g_varchar2)
3711: OR NVL(per_per_shd.g_old_rec.current_employee_flag,hr_api.g_varchar2)
3712: <>NVL(p_current_employee_flag,hr_api.g_varchar2)
3713: --CWK
3714: OR NVL(per_per_shd.g_old_rec.current_npw_flag,hr_api.g_varchar2)
3715: <>NVL(p_current_npw_flag,hr_api.g_varchar2)

Line 3714: OR NVL(per_per_shd.g_old_rec.current_npw_flag,hr_api.g_varchar2)

3710: <>NVL(p_current_emp_or_apl_flag,hr_api.g_varchar2)
3711: OR NVL(per_per_shd.g_old_rec.current_employee_flag,hr_api.g_varchar2)
3712: <>NVL(p_current_employee_flag,hr_api.g_varchar2)
3713: --CWK
3714: OR NVL(per_per_shd.g_old_rec.current_npw_flag,hr_api.g_varchar2)
3715: <>NVL(p_current_npw_flag,hr_api.g_varchar2)
3716: OR NVL(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2)
3717: <>NVL(p_npw_number,hr_api.g_varchar2)
3718: --

Line 3716: OR NVL(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2)

3712: <>NVL(p_current_employee_flag,hr_api.g_varchar2)
3713: --CWK
3714: OR NVL(per_per_shd.g_old_rec.current_npw_flag,hr_api.g_varchar2)
3715: <>NVL(p_current_npw_flag,hr_api.g_varchar2)
3716: OR NVL(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2)
3717: <>NVL(p_npw_number,hr_api.g_varchar2)
3718: --
3719: OR NVL(per_per_shd.g_old_rec.date_employee_data_verified,hr_api.g_date)
3720: <>NVL(p_date_employee_data_verified,hr_api.g_date)

Line 3719: OR NVL(per_per_shd.g_old_rec.date_employee_data_verified,hr_api.g_date)

3715: <>NVL(p_current_npw_flag,hr_api.g_varchar2)
3716: OR NVL(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2)
3717: <>NVL(p_npw_number,hr_api.g_varchar2)
3718: --
3719: OR NVL(per_per_shd.g_old_rec.date_employee_data_verified,hr_api.g_date)
3720: <>NVL(p_date_employee_data_verified,hr_api.g_date)
3721: OR NVL(per_per_shd.g_old_rec.date_of_birth,hr_api.g_date)
3722: <>NVL(p_date_of_birth,hr_api.g_date)
3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)

Line 3721: OR NVL(per_per_shd.g_old_rec.date_of_birth,hr_api.g_date)

3717: <>NVL(p_npw_number,hr_api.g_varchar2)
3718: --
3719: OR NVL(per_per_shd.g_old_rec.date_employee_data_verified,hr_api.g_date)
3720: <>NVL(p_date_employee_data_verified,hr_api.g_date)
3721: OR NVL(per_per_shd.g_old_rec.date_of_birth,hr_api.g_date)
3722: <>NVL(p_date_of_birth,hr_api.g_date)
3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)
3724: <>NVL(p_email_address,hr_api.g_varchar2)
3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)

Line 3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)

3719: OR NVL(per_per_shd.g_old_rec.date_employee_data_verified,hr_api.g_date)
3720: <>NVL(p_date_employee_data_verified,hr_api.g_date)
3721: OR NVL(per_per_shd.g_old_rec.date_of_birth,hr_api.g_date)
3722: <>NVL(p_date_of_birth,hr_api.g_date)
3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)
3724: <>NVL(p_email_address,hr_api.g_varchar2)
3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)
3726: <>NVL(p_employee_number,hr_api.g_varchar2)
3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)

Line 3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)

3721: OR NVL(per_per_shd.g_old_rec.date_of_birth,hr_api.g_date)
3722: <>NVL(p_date_of_birth,hr_api.g_date)
3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)
3724: <>NVL(p_email_address,hr_api.g_varchar2)
3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)
3726: <>NVL(p_employee_number,hr_api.g_varchar2)
3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)
3728: <>NVL(p_expense_check_send_to_addres,hr_api.g_varchar2)
3729: OR NVL(per_per_shd.g_old_rec.first_name,hr_api.g_varchar2)

Line 3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)

3723: OR NVL(per_per_shd.g_old_rec.email_address,hr_api.g_varchar2)
3724: <>NVL(p_email_address,hr_api.g_varchar2)
3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)
3726: <>NVL(p_employee_number,hr_api.g_varchar2)
3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)
3728: <>NVL(p_expense_check_send_to_addres,hr_api.g_varchar2)
3729: OR NVL(per_per_shd.g_old_rec.first_name,hr_api.g_varchar2)
3730: <>NVL(p_first_name,hr_api.g_varchar2)
3731: OR NVL(per_per_shd.g_old_rec.fte_capacity,hr_api.g_number)

Line 3729: OR NVL(per_per_shd.g_old_rec.first_name,hr_api.g_varchar2)

3725: OR NVL(per_per_shd.g_old_rec.employee_number,hr_api.g_varchar2)
3726: <>NVL(p_employee_number,hr_api.g_varchar2)
3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)
3728: <>NVL(p_expense_check_send_to_addres,hr_api.g_varchar2)
3729: OR NVL(per_per_shd.g_old_rec.first_name,hr_api.g_varchar2)
3730: <>NVL(p_first_name,hr_api.g_varchar2)
3731: OR NVL(per_per_shd.g_old_rec.fte_capacity,hr_api.g_number)
3732: <>NVL(p_per_fte_capacity,hr_api.g_number)
3733: --removed for bugfix 2903984

Line 3731: OR NVL(per_per_shd.g_old_rec.fte_capacity,hr_api.g_number)

3727: OR NVL(per_per_shd.g_old_rec.expense_check_send_to_address,hr_api.g_varchar2)
3728: <>NVL(p_expense_check_send_to_addres,hr_api.g_varchar2)
3729: OR NVL(per_per_shd.g_old_rec.first_name,hr_api.g_varchar2)
3730: <>NVL(p_first_name,hr_api.g_varchar2)
3731: OR NVL(per_per_shd.g_old_rec.fte_capacity,hr_api.g_number)
3732: <>NVL(p_per_fte_capacity,hr_api.g_number)
3733: --removed for bugfix 2903984
3734: -- OR NVL(per_per_shd.g_old_rec.full_name,hr_api.g_varchar2)
3735: -- <>NVL(p_full_name,hr_api.g_varchar2)

Line 3734: -- OR NVL(per_per_shd.g_old_rec.full_name,hr_api.g_varchar2)

3730: <>NVL(p_first_name,hr_api.g_varchar2)
3731: OR NVL(per_per_shd.g_old_rec.fte_capacity,hr_api.g_number)
3732: <>NVL(p_per_fte_capacity,hr_api.g_number)
3733: --removed for bugfix 2903984
3734: -- OR NVL(per_per_shd.g_old_rec.full_name,hr_api.g_varchar2)
3735: -- <>NVL(p_full_name,hr_api.g_varchar2)
3736: OR NVL(per_per_shd.g_old_rec.hold_applicant_date_until,hr_api.g_date)
3737: <>NVL(p_hold_applicant_date_until,hr_api.g_date)
3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)

Line 3736: OR NVL(per_per_shd.g_old_rec.hold_applicant_date_until,hr_api.g_date)

3732: <>NVL(p_per_fte_capacity,hr_api.g_number)
3733: --removed for bugfix 2903984
3734: -- OR NVL(per_per_shd.g_old_rec.full_name,hr_api.g_varchar2)
3735: -- <>NVL(p_full_name,hr_api.g_varchar2)
3736: OR NVL(per_per_shd.g_old_rec.hold_applicant_date_until,hr_api.g_date)
3737: <>NVL(p_hold_applicant_date_until,hr_api.g_date)
3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)
3739: <>NVL(p_honors,hr_api.g_varchar2)
3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)

Line 3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)

3734: -- OR NVL(per_per_shd.g_old_rec.full_name,hr_api.g_varchar2)
3735: -- <>NVL(p_full_name,hr_api.g_varchar2)
3736: OR NVL(per_per_shd.g_old_rec.hold_applicant_date_until,hr_api.g_date)
3737: <>NVL(p_hold_applicant_date_until,hr_api.g_date)
3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)
3739: <>NVL(p_honors,hr_api.g_varchar2)
3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)
3741: <>NVL(p_internal_location,hr_api.g_varchar2)
3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)

Line 3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)

3736: OR NVL(per_per_shd.g_old_rec.hold_applicant_date_until,hr_api.g_date)
3737: <>NVL(p_hold_applicant_date_until,hr_api.g_date)
3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)
3739: <>NVL(p_honors,hr_api.g_varchar2)
3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)
3741: <>NVL(p_internal_location,hr_api.g_varchar2)
3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)
3743: <>NVL(p_known_as,hr_api.g_varchar2)
3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)

Line 3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)

3738: OR NVL(per_per_shd.g_old_rec.honors,hr_api.g_varchar2)
3739: <>NVL(p_honors,hr_api.g_varchar2)
3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)
3741: <>NVL(p_internal_location,hr_api.g_varchar2)
3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)
3743: <>NVL(p_known_as,hr_api.g_varchar2)
3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)
3745: <>NVL(p_last_medical_test_by,hr_api.g_varchar2)
3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)

Line 3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)

3740: OR NVL(per_per_shd.g_old_rec.internal_location,hr_api.g_varchar2)
3741: <>NVL(p_internal_location,hr_api.g_varchar2)
3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)
3743: <>NVL(p_known_as,hr_api.g_varchar2)
3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)
3745: <>NVL(p_last_medical_test_by,hr_api.g_varchar2)
3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)
3747: <>NVL(p_last_medical_test_date,hr_api.g_date)
3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)

Line 3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)

3742: OR NVL(per_per_shd.g_old_rec.known_as,hr_api.g_varchar2)
3743: <>NVL(p_known_as,hr_api.g_varchar2)
3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)
3745: <>NVL(p_last_medical_test_by,hr_api.g_varchar2)
3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)
3747: <>NVL(p_last_medical_test_date,hr_api.g_date)
3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)
3749: <>NVL(p_mailstop,hr_api.g_varchar2)
3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)

Line 3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)

3744: OR NVL(per_per_shd.g_old_rec.last_medical_test_by,hr_api.g_varchar2)
3745: <>NVL(p_last_medical_test_by,hr_api.g_varchar2)
3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)
3747: <>NVL(p_last_medical_test_date,hr_api.g_date)
3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)
3749: <>NVL(p_mailstop,hr_api.g_varchar2)
3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)
3751: <>NVL(p_marital_status,hr_api.g_varchar2)
3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)

Line 3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)

3746: OR NVL(per_per_shd.g_old_rec.last_medical_test_date,hr_api.g_date)
3747: <>NVL(p_last_medical_test_date,hr_api.g_date)
3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)
3749: <>NVL(p_mailstop,hr_api.g_varchar2)
3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)
3751: <>NVL(p_marital_status,hr_api.g_varchar2)
3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)
3753: <>NVL(p_middle_names,hr_api.g_varchar2)
3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)

Line 3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)

3748: OR NVL(per_per_shd.g_old_rec.mailstop,hr_api.g_varchar2)
3749: <>NVL(p_mailstop,hr_api.g_varchar2)
3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)
3751: <>NVL(p_marital_status,hr_api.g_varchar2)
3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)
3753: <>NVL(p_middle_names,hr_api.g_varchar2)
3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)
3755: <>NVL(p_nationality,hr_api.g_varchar2)
3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)

Line 3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)

3750: OR NVL(per_per_shd.g_old_rec.marital_status,hr_api.g_varchar2)
3751: <>NVL(p_marital_status,hr_api.g_varchar2)
3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)
3753: <>NVL(p_middle_names,hr_api.g_varchar2)
3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)
3755: <>NVL(p_nationality,hr_api.g_varchar2)
3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)
3757: <>NVL(p_national_identifier,hr_api.g_varchar2)
3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)

Line 3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)

3752: OR NVL(per_per_shd.g_old_rec.middle_names,hr_api.g_varchar2)
3753: <>NVL(p_middle_names,hr_api.g_varchar2)
3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)
3755: <>NVL(p_nationality,hr_api.g_varchar2)
3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)
3757: <>NVL(p_national_identifier,hr_api.g_varchar2)
3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)
3759: <>NVL(p_office_number,hr_api.g_varchar2)
3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)

Line 3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)

3754: OR NVL(per_per_shd.g_old_rec.nationality,hr_api.g_varchar2)
3755: <>NVL(p_nationality,hr_api.g_varchar2)
3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)
3757: <>NVL(p_national_identifier,hr_api.g_varchar2)
3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)
3759: <>NVL(p_office_number,hr_api.g_varchar2)
3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)
3761: <>NVL(p_on_military_service,hr_api.g_varchar2)
3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)

Line 3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)

3756: OR NVL(per_per_shd.g_old_rec.national_identifier,hr_api.g_varchar2)
3757: <>NVL(p_national_identifier,hr_api.g_varchar2)
3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)
3759: <>NVL(p_office_number,hr_api.g_varchar2)
3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)
3761: <>NVL(p_on_military_service,hr_api.g_varchar2)
3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)
3763: <>NVL(p_pre_name_adjunct,hr_api.g_varchar2)
3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)

Line 3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)

3758: OR NVL(per_per_shd.g_old_rec.office_number,hr_api.g_varchar2)
3759: <>NVL(p_office_number,hr_api.g_varchar2)
3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)
3761: <>NVL(p_on_military_service,hr_api.g_varchar2)
3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)
3763: <>NVL(p_pre_name_adjunct,hr_api.g_varchar2)
3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)
3765: <>NVL(p_previous_last_name,hr_api.g_varchar2)
3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)

Line 3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)

3760: OR NVL(per_per_shd.g_old_rec.on_military_service,hr_api.g_varchar2)
3761: <>NVL(p_on_military_service,hr_api.g_varchar2)
3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)
3763: <>NVL(p_pre_name_adjunct,hr_api.g_varchar2)
3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)
3765: <>NVL(p_previous_last_name,hr_api.g_varchar2)
3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)
3767: <>NVL(p_rehire_recommendation,hr_api.g_varchar2)
3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)

Line 3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)

3762: OR NVL(per_per_shd.g_old_rec.pre_name_adjunct,hr_api.g_varchar2)
3763: <>NVL(p_pre_name_adjunct,hr_api.g_varchar2)
3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)
3765: <>NVL(p_previous_last_name,hr_api.g_varchar2)
3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)
3767: <>NVL(p_rehire_recommendation,hr_api.g_varchar2)
3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)
3769: <>NVL(p_rehire_reason,hr_api.g_varchar2)
3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)

Line 3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)

3764: OR NVL(per_per_shd.g_old_rec.previous_last_name,hr_api.g_varchar2)
3765: <>NVL(p_previous_last_name,hr_api.g_varchar2)
3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)
3767: <>NVL(p_rehire_recommendation,hr_api.g_varchar2)
3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)
3769: <>NVL(p_rehire_reason,hr_api.g_varchar2)
3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)
3771: <>NVL(p_resume_exists,hr_api.g_varchar2)
3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)

Line 3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)

3766: OR NVL(per_per_shd.g_old_rec.rehire_recommendation,hr_api.g_varchar2)
3767: <>NVL(p_rehire_recommendation,hr_api.g_varchar2)
3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)
3769: <>NVL(p_rehire_reason,hr_api.g_varchar2)
3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)
3771: <>NVL(p_resume_exists,hr_api.g_varchar2)
3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)
3773: <>NVL(p_resume_last_updated,hr_api.g_date)
3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)

Line 3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)

3768: OR NVL(per_per_shd.g_old_rec.rehire_reason,hr_api.g_varchar2)
3769: <>NVL(p_rehire_reason,hr_api.g_varchar2)
3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)
3771: <>NVL(p_resume_exists,hr_api.g_varchar2)
3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)
3773: <>NVL(p_resume_last_updated,hr_api.g_date)
3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)
3775: <>NVL(p_registered_disabled_flag,hr_api.g_varchar2)
3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)

Line 3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)

3770: OR NVL(per_per_shd.g_old_rec.resume_exists,hr_api.g_varchar2)
3771: <>NVL(p_resume_exists,hr_api.g_varchar2)
3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)
3773: <>NVL(p_resume_last_updated,hr_api.g_date)
3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)
3775: <>NVL(p_registered_disabled_flag,hr_api.g_varchar2)
3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)
3777: <>NVL(p_second_passport_exists,hr_api.g_varchar2)
3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)

Line 3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)

3772: OR NVL(per_per_shd.g_old_rec.resume_last_updated,hr_api.g_date)
3773: <>NVL(p_resume_last_updated,hr_api.g_date)
3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)
3775: <>NVL(p_registered_disabled_flag,hr_api.g_varchar2)
3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)
3777: <>NVL(p_second_passport_exists,hr_api.g_varchar2)
3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)
3779: <>NVL(p_sex,hr_api.g_varchar2)
3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)

Line 3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)

3774: OR NVL(per_per_shd.g_old_rec.registered_disabled_flag,hr_api.g_varchar2)
3775: <>NVL(p_registered_disabled_flag,hr_api.g_varchar2)
3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)
3777: <>NVL(p_second_passport_exists,hr_api.g_varchar2)
3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)
3779: <>NVL(p_sex,hr_api.g_varchar2)
3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)
3781: <>NVL(p_student_status,hr_api.g_varchar2)
3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)

Line 3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)

3776: OR NVL(per_per_shd.g_old_rec.second_passport_exists,hr_api.g_varchar2)
3777: <>NVL(p_second_passport_exists,hr_api.g_varchar2)
3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)
3779: <>NVL(p_sex,hr_api.g_varchar2)
3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)
3781: <>NVL(p_student_status,hr_api.g_varchar2)
3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)
3783: <>NVL(p_suffix,hr_api.g_varchar2)
3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)

Line 3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)

3778: OR NVL(per_per_shd.g_old_rec.sex,hr_api.g_varchar2)
3779: <>NVL(p_sex,hr_api.g_varchar2)
3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)
3781: <>NVL(p_student_status,hr_api.g_varchar2)
3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)
3783: <>NVL(p_suffix,hr_api.g_varchar2)
3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
3785: <>NVL(p_title,hr_api.g_varchar2)
3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)

Line 3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)

3780: OR NVL(per_per_shd.g_old_rec.student_status,hr_api.g_varchar2)
3781: <>NVL(p_student_status,hr_api.g_varchar2)
3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)
3783: <>NVL(p_suffix,hr_api.g_varchar2)
3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
3785: <>NVL(p_title,hr_api.g_varchar2)
3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
3787: <>NVL(p_work_schedule,hr_api.g_varchar2)
3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)

Line 3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)

3782: OR NVL(per_per_shd.g_old_rec.suffix,hr_api.g_varchar2)
3783: <>NVL(p_suffix,hr_api.g_varchar2)
3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
3785: <>NVL(p_title,hr_api.g_varchar2)
3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
3787: <>NVL(p_work_schedule,hr_api.g_varchar2)
3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)
3789: <>NVL(p_coord_ben_med_pln_no,hr_api.g_varchar2)
3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)

Line 3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)

3784: OR NVL(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
3785: <>NVL(p_title,hr_api.g_varchar2)
3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
3787: <>NVL(p_work_schedule,hr_api.g_varchar2)
3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)
3789: <>NVL(p_coord_ben_med_pln_no,hr_api.g_varchar2)
3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)
3791: <>NVL(p_coord_ben_no_cvg_flag,hr_api.g_varchar2)
3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)

Line 3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)

3786: OR NVL(per_per_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
3787: <>NVL(p_work_schedule,hr_api.g_varchar2)
3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)
3789: <>NVL(p_coord_ben_med_pln_no,hr_api.g_varchar2)
3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)
3791: <>NVL(p_coord_ben_no_cvg_flag,hr_api.g_varchar2)
3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)
3793: <>NVL(p_dpdnt_adoption_date,hr_api.g_date)
3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)

Line 3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)

3788: OR NVL(per_per_shd.g_old_rec.coord_ben_med_pln_no,hr_api.g_varchar2)
3789: <>NVL(p_coord_ben_med_pln_no,hr_api.g_varchar2)
3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)
3791: <>NVL(p_coord_ben_no_cvg_flag,hr_api.g_varchar2)
3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)
3793: <>NVL(p_dpdnt_adoption_date,hr_api.g_date)
3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3795: <>NVL(p_dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)

Line 3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)

3790: OR NVL(per_per_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)
3791: <>NVL(p_coord_ben_no_cvg_flag,hr_api.g_varchar2)
3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)
3793: <>NVL(p_dpdnt_adoption_date,hr_api.g_date)
3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3795: <>NVL(p_dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)
3797: <>NVL(p_receipt_of_death_cert_date,hr_api.g_date)
3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)

Line 3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)

3792: OR NVL(per_per_shd.g_old_rec.dpdnt_adoption_date,hr_api.g_date)
3793: <>NVL(p_dpdnt_adoption_date,hr_api.g_date)
3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3795: <>NVL(p_dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)
3797: <>NVL(p_receipt_of_death_cert_date,hr_api.g_date)
3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)
3799: <>NVL(p_uses_tobacco_flag,hr_api.g_varchar2)
3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)

Line 3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)

3794: OR NVL(per_per_shd.g_old_rec.dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3795: <>NVL(p_dpdnt_vlntry_svce_flag,hr_api.g_varchar2)
3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)
3797: <>NVL(p_receipt_of_death_cert_date,hr_api.g_date)
3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)
3799: <>NVL(p_uses_tobacco_flag,hr_api.g_varchar2)
3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)
3801: <>NVL(p_benefit_group_id,hr_api.g_number)
3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

Line 3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)

3796: OR NVL(per_per_shd.g_old_rec.receipt_of_death_cert_date,hr_api.g_date)
3797: <>NVL(p_receipt_of_death_cert_date,hr_api.g_date)
3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)
3799: <>NVL(p_uses_tobacco_flag,hr_api.g_varchar2)
3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)
3801: <>NVL(p_benefit_group_id,hr_api.g_number)
3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
3803: <>NVL(p_attribute_category,hr_api.g_varchar2)
3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)

Line 3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

3798: OR NVL(per_per_shd.g_old_rec.uses_tobacco_flag,hr_api.g_varchar2)
3799: <>NVL(p_uses_tobacco_flag,hr_api.g_varchar2)
3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)
3801: <>NVL(p_benefit_group_id,hr_api.g_number)
3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
3803: <>NVL(p_attribute_category,hr_api.g_varchar2)
3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)
3805: <>NVL(p_attribute1,hr_api.g_varchar2)
3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)

Line 3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)

3800: OR NVL(per_per_shd.g_old_rec.benefit_group_id,hr_api.g_number)
3801: <>NVL(p_benefit_group_id,hr_api.g_number)
3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
3803: <>NVL(p_attribute_category,hr_api.g_varchar2)
3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)
3805: <>NVL(p_attribute1,hr_api.g_varchar2)
3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)
3807: <>NVL(p_attribute2,hr_api.g_varchar2)
3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)

Line 3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)

3802: OR NVL(per_per_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
3803: <>NVL(p_attribute_category,hr_api.g_varchar2)
3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)
3805: <>NVL(p_attribute1,hr_api.g_varchar2)
3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)
3807: <>NVL(p_attribute2,hr_api.g_varchar2)
3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)
3809: <>NVL(p_attribute3,hr_api.g_varchar2)
3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)

Line 3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)

3804: OR NVL(per_per_shd.g_old_rec.attribute1,hr_api.g_varchar2)
3805: <>NVL(p_attribute1,hr_api.g_varchar2)
3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)
3807: <>NVL(p_attribute2,hr_api.g_varchar2)
3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)
3809: <>NVL(p_attribute3,hr_api.g_varchar2)
3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)
3811: <>NVL(p_attribute4,hr_api.g_varchar2)
3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)

Line 3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)

3806: OR NVL(per_per_shd.g_old_rec.attribute2,hr_api.g_varchar2)
3807: <>NVL(p_attribute2,hr_api.g_varchar2)
3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)
3809: <>NVL(p_attribute3,hr_api.g_varchar2)
3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)
3811: <>NVL(p_attribute4,hr_api.g_varchar2)
3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)
3813: <>NVL(p_attribute5,hr_api.g_varchar2)
3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)

Line 3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)

3808: OR NVL(per_per_shd.g_old_rec.attribute3,hr_api.g_varchar2)
3809: <>NVL(p_attribute3,hr_api.g_varchar2)
3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)
3811: <>NVL(p_attribute4,hr_api.g_varchar2)
3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)
3813: <>NVL(p_attribute5,hr_api.g_varchar2)
3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)
3815: <>NVL(p_attribute6,hr_api.g_varchar2)
3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)

Line 3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)

3810: OR NVL(per_per_shd.g_old_rec.attribute4,hr_api.g_varchar2)
3811: <>NVL(p_attribute4,hr_api.g_varchar2)
3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)
3813: <>NVL(p_attribute5,hr_api.g_varchar2)
3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)
3815: <>NVL(p_attribute6,hr_api.g_varchar2)
3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)
3817: <>NVL(p_attribute7,hr_api.g_varchar2)
3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)

Line 3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)

3812: OR NVL(per_per_shd.g_old_rec.attribute5,hr_api.g_varchar2)
3813: <>NVL(p_attribute5,hr_api.g_varchar2)
3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)
3815: <>NVL(p_attribute6,hr_api.g_varchar2)
3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)
3817: <>NVL(p_attribute7,hr_api.g_varchar2)
3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)
3819: <>NVL(p_attribute8,hr_api.g_varchar2)
3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)

Line 3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)

3814: OR NVL(per_per_shd.g_old_rec.attribute6,hr_api.g_varchar2)
3815: <>NVL(p_attribute6,hr_api.g_varchar2)
3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)
3817: <>NVL(p_attribute7,hr_api.g_varchar2)
3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)
3819: <>NVL(p_attribute8,hr_api.g_varchar2)
3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)
3821: <>NVL(p_attribute9,hr_api.g_varchar2)
3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)

Line 3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)

3816: OR NVL(per_per_shd.g_old_rec.attribute7,hr_api.g_varchar2)
3817: <>NVL(p_attribute7,hr_api.g_varchar2)
3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)
3819: <>NVL(p_attribute8,hr_api.g_varchar2)
3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)
3821: <>NVL(p_attribute9,hr_api.g_varchar2)
3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)
3823: <>NVL(p_attribute10,hr_api.g_varchar2)
3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)

Line 3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)

3818: OR NVL(per_per_shd.g_old_rec.attribute8,hr_api.g_varchar2)
3819: <>NVL(p_attribute8,hr_api.g_varchar2)
3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)
3821: <>NVL(p_attribute9,hr_api.g_varchar2)
3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)
3823: <>NVL(p_attribute10,hr_api.g_varchar2)
3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)
3825: <>NVL(p_attribute11,hr_api.g_varchar2)
3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)

Line 3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)

3820: OR NVL(per_per_shd.g_old_rec.attribute9,hr_api.g_varchar2)
3821: <>NVL(p_attribute9,hr_api.g_varchar2)
3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)
3823: <>NVL(p_attribute10,hr_api.g_varchar2)
3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)
3825: <>NVL(p_attribute11,hr_api.g_varchar2)
3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)
3827: <>NVL(p_attribute12,hr_api.g_varchar2)
3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)

Line 3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)

3822: OR NVL(per_per_shd.g_old_rec.attribute10,hr_api.g_varchar2)
3823: <>NVL(p_attribute10,hr_api.g_varchar2)
3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)
3825: <>NVL(p_attribute11,hr_api.g_varchar2)
3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)
3827: <>NVL(p_attribute12,hr_api.g_varchar2)
3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)
3829: <>NVL(p_attribute13,hr_api.g_varchar2)
3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)

Line 3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)

3824: OR NVL(per_per_shd.g_old_rec.attribute11,hr_api.g_varchar2)
3825: <>NVL(p_attribute11,hr_api.g_varchar2)
3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)
3827: <>NVL(p_attribute12,hr_api.g_varchar2)
3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)
3829: <>NVL(p_attribute13,hr_api.g_varchar2)
3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)
3831: <>NVL(p_attribute14,hr_api.g_varchar2)
3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)

Line 3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)

3826: OR NVL(per_per_shd.g_old_rec.attribute12,hr_api.g_varchar2)
3827: <>NVL(p_attribute12,hr_api.g_varchar2)
3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)
3829: <>NVL(p_attribute13,hr_api.g_varchar2)
3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)
3831: <>NVL(p_attribute14,hr_api.g_varchar2)
3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)
3833: <>NVL(p_attribute15,hr_api.g_varchar2)
3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)

Line 3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)

3828: OR NVL(per_per_shd.g_old_rec.attribute13,hr_api.g_varchar2)
3829: <>NVL(p_attribute13,hr_api.g_varchar2)
3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)
3831: <>NVL(p_attribute14,hr_api.g_varchar2)
3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)
3833: <>NVL(p_attribute15,hr_api.g_varchar2)
3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)
3835: <>NVL(p_attribute16,hr_api.g_varchar2)
3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)

Line 3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)

3830: OR NVL(per_per_shd.g_old_rec.attribute14,hr_api.g_varchar2)
3831: <>NVL(p_attribute14,hr_api.g_varchar2)
3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)
3833: <>NVL(p_attribute15,hr_api.g_varchar2)
3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)
3835: <>NVL(p_attribute16,hr_api.g_varchar2)
3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)
3837: <>NVL(p_attribute17,hr_api.g_varchar2)
3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)

Line 3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)

3832: OR NVL(per_per_shd.g_old_rec.attribute15,hr_api.g_varchar2)
3833: <>NVL(p_attribute15,hr_api.g_varchar2)
3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)
3835: <>NVL(p_attribute16,hr_api.g_varchar2)
3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)
3837: <>NVL(p_attribute17,hr_api.g_varchar2)
3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)
3839: <>NVL(p_attribute18,hr_api.g_varchar2)
3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)

Line 3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)

3834: OR NVL(per_per_shd.g_old_rec.attribute16,hr_api.g_varchar2)
3835: <>NVL(p_attribute16,hr_api.g_varchar2)
3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)
3837: <>NVL(p_attribute17,hr_api.g_varchar2)
3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)
3839: <>NVL(p_attribute18,hr_api.g_varchar2)
3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)
3841: <>NVL(p_attribute19,hr_api.g_varchar2)
3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)

Line 3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)

3836: OR NVL(per_per_shd.g_old_rec.attribute17,hr_api.g_varchar2)
3837: <>NVL(p_attribute17,hr_api.g_varchar2)
3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)
3839: <>NVL(p_attribute18,hr_api.g_varchar2)
3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)
3841: <>NVL(p_attribute19,hr_api.g_varchar2)
3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)
3843: <>NVL(p_attribute20,hr_api.g_varchar2)
3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)

Line 3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)

3838: OR NVL(per_per_shd.g_old_rec.attribute18,hr_api.g_varchar2)
3839: <>NVL(p_attribute18,hr_api.g_varchar2)
3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)
3841: <>NVL(p_attribute19,hr_api.g_varchar2)
3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)
3843: <>NVL(p_attribute20,hr_api.g_varchar2)
3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)
3845: <>NVL(p_attribute21,hr_api.g_varchar2)
3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)

Line 3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)

3840: OR NVL(per_per_shd.g_old_rec.attribute19,hr_api.g_varchar2)
3841: <>NVL(p_attribute19,hr_api.g_varchar2)
3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)
3843: <>NVL(p_attribute20,hr_api.g_varchar2)
3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)
3845: <>NVL(p_attribute21,hr_api.g_varchar2)
3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)
3847: <>NVL(p_attribute22,hr_api.g_varchar2)
3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)

Line 3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)

3842: OR NVL(per_per_shd.g_old_rec.attribute20,hr_api.g_varchar2)
3843: <>NVL(p_attribute20,hr_api.g_varchar2)
3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)
3845: <>NVL(p_attribute21,hr_api.g_varchar2)
3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)
3847: <>NVL(p_attribute22,hr_api.g_varchar2)
3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)
3849: <>NVL(p_attribute23,hr_api.g_varchar2)
3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)

Line 3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)

3844: OR NVL(per_per_shd.g_old_rec.attribute21,hr_api.g_varchar2)
3845: <>NVL(p_attribute21,hr_api.g_varchar2)
3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)
3847: <>NVL(p_attribute22,hr_api.g_varchar2)
3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)
3849: <>NVL(p_attribute23,hr_api.g_varchar2)
3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)
3851: <>NVL(p_attribute24,hr_api.g_varchar2)
3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)

Line 3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)

3846: OR NVL(per_per_shd.g_old_rec.attribute22,hr_api.g_varchar2)
3847: <>NVL(p_attribute22,hr_api.g_varchar2)
3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)
3849: <>NVL(p_attribute23,hr_api.g_varchar2)
3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)
3851: <>NVL(p_attribute24,hr_api.g_varchar2)
3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)
3853: <>NVL(p_attribute25,hr_api.g_varchar2)
3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)

Line 3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)

3848: OR NVL(per_per_shd.g_old_rec.attribute23,hr_api.g_varchar2)
3849: <>NVL(p_attribute23,hr_api.g_varchar2)
3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)
3851: <>NVL(p_attribute24,hr_api.g_varchar2)
3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)
3853: <>NVL(p_attribute25,hr_api.g_varchar2)
3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)
3855: <>NVL(p_attribute26,hr_api.g_varchar2)
3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)

Line 3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)

3850: OR NVL(per_per_shd.g_old_rec.attribute24,hr_api.g_varchar2)
3851: <>NVL(p_attribute24,hr_api.g_varchar2)
3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)
3853: <>NVL(p_attribute25,hr_api.g_varchar2)
3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)
3855: <>NVL(p_attribute26,hr_api.g_varchar2)
3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)
3857: <>NVL(p_attribute27,hr_api.g_varchar2)
3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)

Line 3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)

3852: OR NVL(per_per_shd.g_old_rec.attribute25,hr_api.g_varchar2)
3853: <>NVL(p_attribute25,hr_api.g_varchar2)
3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)
3855: <>NVL(p_attribute26,hr_api.g_varchar2)
3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)
3857: <>NVL(p_attribute27,hr_api.g_varchar2)
3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)
3859: <>NVL(p_attribute28,hr_api.g_varchar2)
3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)

Line 3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)

3854: OR NVL(per_per_shd.g_old_rec.attribute26,hr_api.g_varchar2)
3855: <>NVL(p_attribute26,hr_api.g_varchar2)
3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)
3857: <>NVL(p_attribute27,hr_api.g_varchar2)
3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)
3859: <>NVL(p_attribute28,hr_api.g_varchar2)
3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)
3861: <>NVL(p_attribute29,hr_api.g_varchar2)
3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)

Line 3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)

3856: OR NVL(per_per_shd.g_old_rec.attribute27,hr_api.g_varchar2)
3857: <>NVL(p_attribute27,hr_api.g_varchar2)
3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)
3859: <>NVL(p_attribute28,hr_api.g_varchar2)
3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)
3861: <>NVL(p_attribute29,hr_api.g_varchar2)
3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)
3863: <>NVL(p_attribute30,hr_api.g_varchar2)
3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)

Line 3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)

3858: OR NVL(per_per_shd.g_old_rec.attribute28,hr_api.g_varchar2)
3859: <>NVL(p_attribute28,hr_api.g_varchar2)
3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)
3861: <>NVL(p_attribute29,hr_api.g_varchar2)
3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)
3863: <>NVL(p_attribute30,hr_api.g_varchar2)
3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)
3865: <>NVL(p_per_information_category,hr_api.g_varchar2)
3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)

Line 3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)

3860: OR NVL(per_per_shd.g_old_rec.attribute29,hr_api.g_varchar2)
3861: <>NVL(p_attribute29,hr_api.g_varchar2)
3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)
3863: <>NVL(p_attribute30,hr_api.g_varchar2)
3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)
3865: <>NVL(p_per_information_category,hr_api.g_varchar2)
3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
3867: <>NVL(p_per_information1,hr_api.g_varchar2)
3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)

Line 3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)

3862: OR NVL(per_per_shd.g_old_rec.attribute30,hr_api.g_varchar2)
3863: <>NVL(p_attribute30,hr_api.g_varchar2)
3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)
3865: <>NVL(p_per_information_category,hr_api.g_varchar2)
3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
3867: <>NVL(p_per_information1,hr_api.g_varchar2)
3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
3869: <>NVL(p_per_information2,hr_api.g_varchar2)
3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)

Line 3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)

3864: OR NVL(per_per_shd.g_old_rec.per_information_category,hr_api.g_varchar2)
3865: <>NVL(p_per_information_category,hr_api.g_varchar2)
3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
3867: <>NVL(p_per_information1,hr_api.g_varchar2)
3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
3869: <>NVL(p_per_information2,hr_api.g_varchar2)
3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
3871: <>NVL(p_per_information3,hr_api.g_varchar2)
3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)

Line 3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)

3866: OR NVL(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
3867: <>NVL(p_per_information1,hr_api.g_varchar2)
3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
3869: <>NVL(p_per_information2,hr_api.g_varchar2)
3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
3871: <>NVL(p_per_information3,hr_api.g_varchar2)
3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
3873: <>NVL(p_per_information4,hr_api.g_varchar2)
3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)

Line 3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)

3868: OR NVL(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
3869: <>NVL(p_per_information2,hr_api.g_varchar2)
3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
3871: <>NVL(p_per_information3,hr_api.g_varchar2)
3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
3873: <>NVL(p_per_information4,hr_api.g_varchar2)
3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
3875: <>NVL(p_per_information5,hr_api.g_varchar2)
3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)

Line 3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)

3870: OR NVL(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
3871: <>NVL(p_per_information3,hr_api.g_varchar2)
3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
3873: <>NVL(p_per_information4,hr_api.g_varchar2)
3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
3875: <>NVL(p_per_information5,hr_api.g_varchar2)
3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
3877: <>NVL(p_per_information6,hr_api.g_varchar2)
3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)

Line 3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)

3872: OR NVL(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
3873: <>NVL(p_per_information4,hr_api.g_varchar2)
3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
3875: <>NVL(p_per_information5,hr_api.g_varchar2)
3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
3877: <>NVL(p_per_information6,hr_api.g_varchar2)
3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
3879: <>NVL(p_per_information7,hr_api.g_varchar2)
3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)

Line 3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)

3874: OR NVL(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
3875: <>NVL(p_per_information5,hr_api.g_varchar2)
3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
3877: <>NVL(p_per_information6,hr_api.g_varchar2)
3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
3879: <>NVL(p_per_information7,hr_api.g_varchar2)
3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
3881: <>NVL(p_per_information8,hr_api.g_varchar2)
3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)

Line 3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)

3876: OR NVL(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
3877: <>NVL(p_per_information6,hr_api.g_varchar2)
3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
3879: <>NVL(p_per_information7,hr_api.g_varchar2)
3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
3881: <>NVL(p_per_information8,hr_api.g_varchar2)
3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
3883: <>NVL(p_per_information9,hr_api.g_varchar2)
3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)

Line 3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)

3878: OR NVL(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
3879: <>NVL(p_per_information7,hr_api.g_varchar2)
3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
3881: <>NVL(p_per_information8,hr_api.g_varchar2)
3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
3883: <>NVL(p_per_information9,hr_api.g_varchar2)
3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
3885: <>NVL(p_per_information10,hr_api.g_varchar2)
3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)

Line 3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)

3880: OR NVL(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
3881: <>NVL(p_per_information8,hr_api.g_varchar2)
3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
3883: <>NVL(p_per_information9,hr_api.g_varchar2)
3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
3885: <>NVL(p_per_information10,hr_api.g_varchar2)
3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)
3887: <>NVL(p_per_information11,hr_api.g_varchar2)
3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)

Line 3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)

3882: OR NVL(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
3883: <>NVL(p_per_information9,hr_api.g_varchar2)
3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
3885: <>NVL(p_per_information10,hr_api.g_varchar2)
3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)
3887: <>NVL(p_per_information11,hr_api.g_varchar2)
3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)
3889: <>NVL(p_per_information12,hr_api.g_varchar2)
3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)

Line 3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)

3884: OR NVL(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
3885: <>NVL(p_per_information10,hr_api.g_varchar2)
3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)
3887: <>NVL(p_per_information11,hr_api.g_varchar2)
3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)
3889: <>NVL(p_per_information12,hr_api.g_varchar2)
3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)
3891: <>NVL(p_per_information13,hr_api.g_varchar2)
3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)

Line 3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)

3886: OR NVL(per_per_shd.g_old_rec.per_information11,hr_api.g_varchar2)
3887: <>NVL(p_per_information11,hr_api.g_varchar2)
3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)
3889: <>NVL(p_per_information12,hr_api.g_varchar2)
3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)
3891: <>NVL(p_per_information13,hr_api.g_varchar2)
3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)
3893: <>NVL(p_per_information14,hr_api.g_varchar2)
3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)

Line 3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)

3888: OR NVL(per_per_shd.g_old_rec.per_information12,hr_api.g_varchar2)
3889: <>NVL(p_per_information12,hr_api.g_varchar2)
3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)
3891: <>NVL(p_per_information13,hr_api.g_varchar2)
3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)
3893: <>NVL(p_per_information14,hr_api.g_varchar2)
3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)
3895: <>NVL(p_per_information15,hr_api.g_varchar2)
3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)

Line 3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)

3890: OR NVL(per_per_shd.g_old_rec.per_information13,hr_api.g_varchar2)
3891: <>NVL(p_per_information13,hr_api.g_varchar2)
3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)
3893: <>NVL(p_per_information14,hr_api.g_varchar2)
3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)
3895: <>NVL(p_per_information15,hr_api.g_varchar2)
3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)
3897: <>NVL(p_per_information16,hr_api.g_varchar2)
3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)

Line 3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)

3892: OR NVL(per_per_shd.g_old_rec.per_information14,hr_api.g_varchar2)
3893: <>NVL(p_per_information14,hr_api.g_varchar2)
3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)
3895: <>NVL(p_per_information15,hr_api.g_varchar2)
3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)
3897: <>NVL(p_per_information16,hr_api.g_varchar2)
3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)
3899: <>NVL(p_per_information17,hr_api.g_varchar2)
3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)

Line 3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)

3894: OR NVL(per_per_shd.g_old_rec.per_information15,hr_api.g_varchar2)
3895: <>NVL(p_per_information15,hr_api.g_varchar2)
3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)
3897: <>NVL(p_per_information16,hr_api.g_varchar2)
3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)
3899: <>NVL(p_per_information17,hr_api.g_varchar2)
3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)
3901: <>NVL(p_per_information18,hr_api.g_varchar2)
3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)

Line 3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)

3896: OR NVL(per_per_shd.g_old_rec.per_information16,hr_api.g_varchar2)
3897: <>NVL(p_per_information16,hr_api.g_varchar2)
3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)
3899: <>NVL(p_per_information17,hr_api.g_varchar2)
3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)
3901: <>NVL(p_per_information18,hr_api.g_varchar2)
3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)
3903: <>NVL(p_per_information19,hr_api.g_varchar2)
3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)

Line 3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)

3898: OR NVL(per_per_shd.g_old_rec.per_information17,hr_api.g_varchar2)
3899: <>NVL(p_per_information17,hr_api.g_varchar2)
3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)
3901: <>NVL(p_per_information18,hr_api.g_varchar2)
3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)
3903: <>NVL(p_per_information19,hr_api.g_varchar2)
3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)
3905: <>NVL(p_per_information20,hr_api.g_varchar2)
3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)

Line 3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)

3900: OR NVL(per_per_shd.g_old_rec.per_information18,hr_api.g_varchar2)
3901: <>NVL(p_per_information18,hr_api.g_varchar2)
3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)
3903: <>NVL(p_per_information19,hr_api.g_varchar2)
3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)
3905: <>NVL(p_per_information20,hr_api.g_varchar2)
3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)
3907: <>NVL(p_per_information21,hr_api.g_varchar2)
3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)

Line 3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)

3902: OR NVL(per_per_shd.g_old_rec.per_information19,hr_api.g_varchar2)
3903: <>NVL(p_per_information19,hr_api.g_varchar2)
3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)
3905: <>NVL(p_per_information20,hr_api.g_varchar2)
3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)
3907: <>NVL(p_per_information21,hr_api.g_varchar2)
3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)
3909: <>NVL(p_per_information22,hr_api.g_varchar2)
3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)

Line 3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)

3904: OR NVL(per_per_shd.g_old_rec.per_information20,hr_api.g_varchar2)
3905: <>NVL(p_per_information20,hr_api.g_varchar2)
3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)
3907: <>NVL(p_per_information21,hr_api.g_varchar2)
3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)
3909: <>NVL(p_per_information22,hr_api.g_varchar2)
3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)
3911: <>NVL(p_per_information23,hr_api.g_varchar2)
3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)

Line 3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)

3906: OR NVL(per_per_shd.g_old_rec.per_information21,hr_api.g_varchar2)
3907: <>NVL(p_per_information21,hr_api.g_varchar2)
3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)
3909: <>NVL(p_per_information22,hr_api.g_varchar2)
3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)
3911: <>NVL(p_per_information23,hr_api.g_varchar2)
3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)
3913: <>NVL(p_per_information24,hr_api.g_varchar2)
3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)

Line 3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)

3908: OR NVL(per_per_shd.g_old_rec.per_information22,hr_api.g_varchar2)
3909: <>NVL(p_per_information22,hr_api.g_varchar2)
3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)
3911: <>NVL(p_per_information23,hr_api.g_varchar2)
3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)
3913: <>NVL(p_per_information24,hr_api.g_varchar2)
3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)
3915: <>NVL(p_per_information25,hr_api.g_varchar2)
3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)

Line 3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)

3910: OR NVL(per_per_shd.g_old_rec.per_information23,hr_api.g_varchar2)
3911: <>NVL(p_per_information23,hr_api.g_varchar2)
3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)
3913: <>NVL(p_per_information24,hr_api.g_varchar2)
3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)
3915: <>NVL(p_per_information25,hr_api.g_varchar2)
3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)
3917: <>NVL(p_per_information26,hr_api.g_varchar2)
3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)

Line 3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)

3912: OR NVL(per_per_shd.g_old_rec.per_information24,hr_api.g_varchar2)
3913: <>NVL(p_per_information24,hr_api.g_varchar2)
3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)
3915: <>NVL(p_per_information25,hr_api.g_varchar2)
3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)
3917: <>NVL(p_per_information26,hr_api.g_varchar2)
3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)
3919: <>NVL(p_per_information27,hr_api.g_varchar2)
3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)

Line 3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)

3914: OR NVL(per_per_shd.g_old_rec.per_information25,hr_api.g_varchar2)
3915: <>NVL(p_per_information25,hr_api.g_varchar2)
3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)
3917: <>NVL(p_per_information26,hr_api.g_varchar2)
3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)
3919: <>NVL(p_per_information27,hr_api.g_varchar2)
3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)
3921: <>NVL(p_per_information28,hr_api.g_varchar2)
3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)

Line 3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)

3916: OR NVL(per_per_shd.g_old_rec.per_information26,hr_api.g_varchar2)
3917: <>NVL(p_per_information26,hr_api.g_varchar2)
3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)
3919: <>NVL(p_per_information27,hr_api.g_varchar2)
3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)
3921: <>NVL(p_per_information28,hr_api.g_varchar2)
3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)
3923: <>NVL(p_per_information29,hr_api.g_varchar2)
3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)

Line 3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)

3918: OR NVL(per_per_shd.g_old_rec.per_information27,hr_api.g_varchar2)
3919: <>NVL(p_per_information27,hr_api.g_varchar2)
3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)
3921: <>NVL(p_per_information28,hr_api.g_varchar2)
3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)
3923: <>NVL(p_per_information29,hr_api.g_varchar2)
3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)
3925: <>NVL(p_per_information30,hr_api.g_varchar2)
3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)

Line 3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)

3920: OR NVL(per_per_shd.g_old_rec.per_information28,hr_api.g_varchar2)
3921: <>NVL(p_per_information28,hr_api.g_varchar2)
3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)
3923: <>NVL(p_per_information29,hr_api.g_varchar2)
3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)
3925: <>NVL(p_per_information30,hr_api.g_varchar2)
3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)
3927: <>NVL(p_date_of_death,hr_api.g_date)
3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)

Line 3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)

3922: OR NVL(per_per_shd.g_old_rec.per_information29,hr_api.g_varchar2)
3923: <>NVL(p_per_information29,hr_api.g_varchar2)
3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)
3925: <>NVL(p_per_information30,hr_api.g_varchar2)
3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)
3927: <>NVL(p_date_of_death,hr_api.g_date)
3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3929: <>NVL(p_original_date_of_hire,hr_api.g_date)
3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)

Line 3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)

3924: OR NVL(per_per_shd.g_old_rec.per_information30,hr_api.g_varchar2)
3925: <>NVL(p_per_information30,hr_api.g_varchar2)
3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)
3927: <>NVL(p_date_of_death,hr_api.g_date)
3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3929: <>NVL(p_original_date_of_hire,hr_api.g_date)
3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)
3931: <>NVL(p_adjusted_svc_date,hr_api.g_date)
3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)

Line 3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)

3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3929: <>NVL(p_original_date_of_hire,hr_api.g_date)
3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)
3931: <>NVL(p_adjusted_svc_date,hr_api.g_date)
3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)
3933: <>NVL(p_town_of_birth,hr_api.g_varchar2)
3934: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)
3935: <>NVL(p_region_of_birth,hr_api.g_varchar2)
3936: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)

Line 3934: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)

3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)
3931: <>NVL(p_adjusted_svc_date,hr_api.g_date)
3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)
3933: <>NVL(p_town_of_birth,hr_api.g_varchar2)
3934: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)
3935: <>NVL(p_region_of_birth,hr_api.g_varchar2)
3936: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)
3937: <>NVL(p_country_of_birth,hr_api.g_varchar2)
3938: ) THEN

Line 3936: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)

3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)
3933: <>NVL(p_town_of_birth,hr_api.g_varchar2)
3934: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)
3935: <>NVL(p_region_of_birth,hr_api.g_varchar2)
3936: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)
3937: <>NVL(p_country_of_birth,hr_api.g_varchar2)
3938: ) THEN
3939: --
3940: hr_utility.set_location(l_proc, 40);

Line 7138: per_per_shd.lck

7134: ELSE
7135: l_per_datetrack_update_mode:=p_datetrack_update_mode;
7136: END IF;
7137:
7138: per_per_shd.lck
7139: (p_effective_date => p_effective_date
7140: ,p_datetrack_mode => l_per_datetrack_update_mode
7141: ,p_person_id => p_person_id
7142: ,p_object_version_number => p_per_object_version_number