DBA Data[Home] [Help]

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: