DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_ELEMENT_LINKS_F

Line 846: AND EXISTS (select null from pay_element_links_f pelf

842: AND prr.run_result_id = prrv.run_result_id
843: AND piv_pay.input_value_id = prrv.input_value_id
844: AND run_paa.assignment_id = peef.assignment_id
845: and ppp.personal_payment_method_id = peef.personal_payment_method_id
846: AND EXISTS (select null from pay_element_links_f pelf
847: where pelf.element_link_id= peef.element_link_id
848: and pelf.element_type_id = pet.element_type_id
849: and run_ppa.date_earned between pelf.effective_start_date
850: and pelf.effective_end_date)