APPS.PER_IN_DATA_PUMP dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 22: FROM hr_pump_batch_line_user_keys

18: l_id NUMBER;
19: BEGIN
20: SELECT unique_key_id
21: INTO l_id
22: FROM hr_pump_batch_line_user_keys
23: WHERE user_key_value = p_user_key_value;
24:
25: RETURN(l_id);
26: END user_key_to_id;

Line 51: ,hr_pump_batch_line_user_keys key

47: BEGIN
48: SELECT opm.object_version_number
49: INTO l_ovn
50: FROM PAY_ORG_PAYMENT_METHODS_F opm
51: ,hr_pump_batch_line_user_keys key
52: WHERE key.user_key_value = p_org_payment_method_user_key
53: AND opm.ORG_PAYMENT_METHOD_ID = key.unique_key_id
54: AND p_effective_date between
55: opm.effective_start_date and opm.effective_end_date;

Line 104: hr_pump_batch_line_user_keys key

100: BEGIN
101: SELECT ctk_rel.object_version_number
102: INTO l_contact_relationship_ovn
103: FROM per_contact_relationships ctk_rel,
104: hr_pump_batch_line_user_keys key
105: WHERE key.user_key_value = p_contact_rel_user_key
106: AND ctk_rel.contact_relationship_id = key.unique_key_id;
107:
108: RETURN l_contact_relationship_ovn;

Line 145: hr_pump_batch_line_user_keys key

141: BEGIN
142: SELECT contact_info.object_version_number
143: INTO l_ovn
144: FROM per_contact_extra_info_f contact_info,
145: hr_pump_batch_line_user_keys key
146: WHERE key.user_key_value = p_contact_extra_info_user_key
147: AND contact_info.contact_extra_info_id = key.unique_key_id
148: AND p_effective_date BETWEEN
149: contact_info.effective_start_date AND contact_info.effective_end_date;

Line 178: hr_pump_batch_line_user_keys key

174: BEGIN
175: SELECT people_extra_info.object_version_number
176: INTO l_person_extra_info_ovn
177: FROM per_people_extra_info people_extra_info,
178: hr_pump_batch_line_user_keys key
179: WHERE key.user_key_value = p_person_extra_info_user_key
180: AND people_extra_info.PERSON_EXTRA_INFO_ID = key.unique_key_id;
181:
182: RETURN l_person_extra_info_ovn;