DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_QUICKPAY_EXCLUSIONS

Line 2663: AND NOT EXISTS (SELECT 1 FROM pay_quickpay_exclusions pqe

2659: AND et.element_type_id= p_element_type_id
2660: AND pa.date_earned BETWEEN et.effective_start_date
2661: AND et.effective_end_date
2662: AND aa.assignment_action_id = p_assignment_action_id
2663: AND NOT EXISTS (SELECT 1 FROM pay_quickpay_exclusions pqe
2664: WHERE pqe.assignment_action_id =nvl(aa.source_action_id,aa.assignment_Action_id)
2665: AND pqe.element_entry_id = ee.element_entry_id)
2666: ORDER BY ee.element_entry_id ;
2667: