DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1482: pay_element_links_f pel,

1478: cursor stp is
1479: select pet.multiple_entries_allowed_flag,
1480: pee.element_entry_id,pee.updating_action_type
1481: from pay_element_types_f pet,
1482: pay_element_links_f pel,
1483: pay_element_entries_f pee
1484: where pee.assignment_id = p_info.assignment_id
1485: and pee.entry_type = 'E'
1486: and pel.element_link_id = pee.element_link_id

Line 1509: pay_element_links_f pel,

1505: cursor upd is
1506: select pet.multiple_entries_allowed_flag,
1507: pee.element_entry_id
1508: from pay_element_types_f pet,
1509: pay_element_links_f pel,
1510: pay_element_entries_f pee
1511: where pee.assignment_id = p_info.assignment_id
1512: and pee.entry_type = 'E'
1513: and ((pee.effective_start_date = p_info.action_date