APPS.IGS_AD_IMP_006 dependencies on HZ_EMPLOYMENT_HISTORY

Line 26: pkpatel 23-Feb-2006 Bug 4937960 (Used the table HZ_EMPLOYMENT_HISTORY directly instead of the view IGS_AD_EMP_DTL)

22: npalanis 14-JUN-2002 Bug - 2409967
23: the cursor check is put inside the check for error code.
24: gmaheswa 10-NOV-2003 Bug - 3223043 HZ.K impact changes
25: gmaheswa 15-DEC-2003 Bug 3316838 Removed code related to date overlap under same employer or employer party number.
26: pkpatel 23-Feb-2006 Bug 4937960 (Used the table HZ_EMPLOYMENT_HISTORY directly instead of the view IGS_AD_EMP_DTL)
27: skpandey 16-May-2006 Bug - 5205911 added comments column to IGS_AD_EMP_INT_ALL
28: */
29: --1
30:

Line 608: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

604: match_ind = '19'
605: WHERE mi.interface_run_id = l_interface_run_id
606: AND mi.status = '2'
607: AND EXISTS ( SELECT '1'
608: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
609: WHERE ii.interface_run_id = l_interface_run_id
610: AND ii.interface_id = mi.interface_id
611: AND pe.employed_by_party_id = hz.party_id(+)
612: AND ii.person_id = pe.party_id

Line 647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz

643: WHERE mi.interface_run_id = l_interface_run_id
644: AND mi.match_ind IS NULL
645: AND mi.status = '2'
646: AND EXISTS ( SELECT '1'
647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz
648: WHERE ii.interface_run_id = l_interface_run_id
649: AND ii.interface_id = mi.interface_id
650: AND ii.person_id = pe.party_id
651: AND pe.employment_history_id = ahed.employment_history_id (+)

Line 676: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

672: UPDATE igs_ad_emp_int_all mi
673: SET status = '3',
674: match_ind = '20',
675: dup_employment_number = (SELECT employment_history_id
676: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
677: WHERE ii.interface_run_id = l_interface_run_id
678: AND ii.interface_id = mi.interface_id
679: AND ii.person_id = pe.party_id
680: AND pe.employed_by_party_id = hz.party_id (+)

Line 689: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

685: WHERE mi.interface_run_id = l_interface_run_id
686: AND mi.match_ind IS NULL
687: AND mi.status = '2'
688: AND EXISTS (SELECT '1'
689: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
690: WHERE ii.interface_run_id = l_interface_run_id
691: AND ii.interface_id = mi.interface_id
692: AND ii.person_id = pe.party_id
693: AND pe.employed_by_party_id = hz.party_id (+)

Line 730: FROM hz_employment_history heh, igs_ad_hz_emp_dtl ahed, hz_parties hz

726: heh.object_version_number,
727: heh.employed_by_party_id,
728: heh.reason_for_leaving reason_for_leaving,
729: null occupational_title
730: FROM hz_employment_history heh, igs_ad_hz_emp_dtl ahed, hz_parties hz
731: WHERE heh.party_id = cp_person_id
732: AND heh.employment_history_id = ahed.employment_history_id (+)
733: AND heh.employed_by_party_id = hz.party_id (+)
734: AND ( NVL(UPPER(heh.employed_by_name_company),'!*!') = NVL(UPPER(cp_employer),'!*!')