DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 860: AND EXISTS (select null from pay_element_links_f pelf

856: pay_input_values_f piv_att,
857: pay_element_entries_f peef,
858: pay_element_types_f pet
859: where peef.assignment_id = cp_asg_id
860: AND EXISTS (select null from pay_element_links_f pelf
861: where pelf.element_link_id= peef.element_link_id
862: and pelf.element_type_id = pet.element_type_id
863: and cp_effective_date between
864: pelf.effective_start_date and pelf.effective_end_date /* BUG: 5383895 date_earned changed to effective_date */