DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_RUN_RESULTS

Line 3762: INDEX(rr PAY_RUN_RESULTS_N50)

3758: USE_NL(pbl ppa pbf paa rr rrv)
3759: INDEX(pbl PAY_BALANCE_BATCH_LINES_N51)
3760: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
3761: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
3762: INDEX(rr PAY_RUN_RESULTS_N50)
3763: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
3764: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */
3765: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3766: paa.assignment_action_id),16))

Line 3772: pay_run_results rr,

3768: from
3769: pay_balance_batch_lines pbl,
3770: pay_payroll_actions ppa,
3771: pay_assignment_actions paa,
3772: pay_run_results rr,
3773: pay_run_result_values rrv,
3774: pay_balance_feeds_f pbf
3775: where pbl.batch_id = p_glbl_data_rec.batch_id
3776: and pbl.assignment_id = p_glbl_data_rec.assignment_id