APPS.PAY_ES_RUN_TYPES dependencies on PAY_ELEMENT_TYPE_USAGES_F
Line 102: FROM pay_element_type_usages_f petu
98: WHERE legislation_code = 'ES'
99: AND prt.shortname = 'TAX_WITHHOLDING_RATE'
100: AND p_effective_date between effective_start_date and effective_end_date
101: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL 102: FROM pay_element_type_usages_f petu 103: WHERE petu.RUN_TYPE_ID = prt.RUN_TYPE_ID
104: AND petu.ELEMENT_TYPE_ID = p_ELEMENT_TYPE_ID
105: AND p_effective_date between petu.effective_start_date and petu.effective_end_date);
106: