APPS.ENG_PERSON dependencies on HZ_PARTIES

Line 28: from hz_parties

24: where not exists (
25: select null
26: from eng_engineering_changes eng
27: where eng.requestor_id in (select party_id
28: from hz_parties
29: where person_identifier = to_char(p_person_id)));
30: exception
31: when NO_DATA_FOUND then
32: hr_utility.set_message (801, 'HR_6249_ALL_ENG_PER_NO_DEL');

Line 46: from hz_parties

42: where not exists (
43: select null
44: from eng_current_scheduled_dates eng
45: where eng.employee_id in (select party_id
46: from hz_parties
47: where person_identifier = to_char(p_person_id)));
48: exception
49: when NO_DATA_FOUND then
50: hr_utility.set_message (801, 'HR_6271_ALL_ENG2_PER_NO_DEL');

Line 80: from hz_parties

76: where not exists (
77: select null
78: from eng_eng_changes_interface eng
79: where eng.requestor_id in (select party_id
80: from hz_parties
81: where person_identifier = to_char(p_person_id)));
82: exception
83: when NO_DATA_FOUND then
84: hr_utility.set_message (801, 'HR_6273_ALL_ENG4_PER_NO_DEL');