DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_QUICKPAY_EXCLUSIONS

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

2224: AND et.element_type_id= p_element_type_id
2225: AND pa.date_earned BETWEEN et.effective_start_date
2226: AND et.effective_end_date
2227: AND aa.assignment_action_id = p_assignment_action_id
2228: AND NOT EXISTS (SELECT 1 FROM pay_quickpay_exclusions pqe
2229: WHERE pqe.assignment_action_id =nvl(aa.source_action_id,aa.assignment_Action_id))
2230: ORDER BY ee.element_entry_id ;
2231:
2232: /* Cursor to find the screen entry value */