APPS.IGS_AD_IMP_006 dependencies on HZ_PARTIES

Line 297: FROM HZ_PARTIES

293: WHERE person_id = cp_person_id;
294:
295: CURSOR employer_party_number_cur(cp_employer_party_number igs_ad_emp_int_all.employer_party_number%TYPE) IS
296: SELECT PARTY_ID
297: FROM HZ_PARTIES
298: WHERE party_type = 'ORGANIZATION' AND
299: party_number = cp_employer_party_number AND
300: status <> 'M';
301:

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),'!*!')