DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 403: pay_balance_feeds_f pbf

399: /*+ ordered
400: use_nl (piv prrv) */
401: count(1)
402: from
403: pay_balance_feeds_f pbf
404: ,pay_input_values_f piv
405: ,pay_run_result_values prrv
406: where
407: pbf.balance_type_id = p_baltypid

Line 438: pay_balance_feeds_f pbf

434: index (purge_paa PAY_ASSIGNMENT_ACTIONS_N51)
435: use_nl (piv prr paa ppa purge_paa prrv) */
436: 1
437: from
438: pay_balance_feeds_f pbf
439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa

Line 1419: from pay_balance_feeds_f pbf,

1415: -- the types, feeds and input values all exist
1416: -- across the whole of time.
1417: select 1
1418: into l_dummy
1419: from pay_balance_feeds_f pbf,
1420: pay_input_values_f piv,
1421: pay_element_types_f pet,
1422: pay_element_classifications pec
1423: where pbf.balance_type_id = c1rec.balance_type_id