APPS.PA_PERSON dependencies on PA_BILL_RATES

Line 226: select /*+ INDEX ( pa PA_BILL_RATES_U1 ) */

222: select 'Y'
223: into v_delete_permitted
224: from sys.dual
225: where not exists (
226: select /*+ INDEX ( pa PA_BILL_RATES_U1 ) */
227: null
228: from pa_bill_rates pa
229: where pa.bill_rate_organization_id > -1
230: and pa.std_bill_rate_schedule <> 'DUMMY'

Line 228: from pa_bill_rates pa

224: from sys.dual
225: where not exists (
226: select /*+ INDEX ( pa PA_BILL_RATES_U1 ) */
227: null
228: from pa_bill_rates pa
229: where pa.bill_rate_organization_id > -1
230: and pa.std_bill_rate_schedule <> 'DUMMY'
231: and pa.person_id = P_PERSON_ID);
232: exception