DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 414: pay_element_links_f pel,

410: /*
411: cursor csr_get_assignment is
412: select distinct pee.assignment_id assignment_id, asg.assignment_number
413: from pay_element_entries_f pee,
414: pay_element_links_f pel,
415: per_all_assignments_f asg
416: where pee.element_type_id = p_plan_ele_type_id
417: and pee.element_type_id = pel.element_type_id
418: and pee.element_link_id = pel.element_link_id

Line 429: pay_element_links_f pel,

425:
426: cursor csr_get_assignment is
427: select distinct pee.assignment_id assignment_id, asg.assignment_number
428: from pay_element_entries_f pee,
429: pay_element_links_f pel,
430: per_all_assignments_f asg,
431: per_periods_of_service pds
432: where pee.element_type_id = p_plan_ele_type_id
433: and pee.element_type_id = pel.element_type_id