DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on PAY_ELEMENT_LINKS_F

Line 273: pay_element_links_f el,

269: l_element_name
270: FROM hr_h2pi_element_entries ee,
271: hr_h2pi_id_mapping map,
272: hr_h2pi_id_mapping map2,
273: pay_element_links_f el,
274: pay_element_types_f et,
275: hr_h2pi_assignments_v asg
276: WHERE ee.element_entry_id = csr_rec.from_id
277: --AND ee.business_group_id = l_from_business_group_id

Line 280: AND map.table_name = 'PAY_ELEMENT_LINKS_F'

276: WHERE ee.element_entry_id = csr_rec.from_id
277: --AND ee.business_group_id = l_from_business_group_id
278: AND ee.client_id = l_from_client_id
279: AND ee.element_link_id = map.from_id
280: AND map.table_name = 'PAY_ELEMENT_LINKS_F'
281: AND map.to_business_group_id = csr_rec.to_business_group_id
282: AND map.to_id = el.element_link_id
283: AND el.element_type_id = et.element_type_id
284: AND ee.assignment_id = map2.from_id