DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1487: pay_element_links_f pel,

1483: cursor stp is
1484: select pet.multiple_entries_allowed_flag,
1485: pee.element_entry_id,pee.updating_action_type
1486: from pay_element_types_f pet,
1487: pay_element_links_f pel,
1488: pay_element_entries_f pee
1489: where pee.assignment_id = p_info.assignment_id
1490: and pee.entry_type = 'E'
1491: and pel.element_link_id = pee.element_link_id

Line 1514: pay_element_links_f pel,

1510: cursor upd is
1511: select pet.multiple_entries_allowed_flag,
1512: pee.element_entry_id
1513: from pay_element_types_f pet,
1514: pay_element_links_f pel,
1515: pay_element_entries_f pee
1516: where pee.assignment_id = p_info.assignment_id
1517: and pee.entry_type = 'E'
1518: and ((pee.effective_start_date = p_info.action_date