DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 843: AND EXISTS (select null from pay_element_links_f pelf

839: pay_input_values_f piv_att,
840: pay_element_entries_f peef,
841: pay_element_types_f pet
842: where peef.assignment_id = cp_asg_id
843: AND EXISTS (select null from pay_element_links_f pelf
844: where pelf.element_link_id= peef.element_link_id
845: and pelf.element_type_id = pet.element_type_id
846: and cp_effective_date between
847: pelf.effective_start_date and pelf.effective_end_date /* BUG: 5383895 date_earned changed to effective_date */