DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_RUN_RESULTS

Line 3469: INDEX(rr PAY_RUN_RESULTS_N50)

3465: USE_NL(pbl ppa pbf paa rr rrv)
3466: INDEX(pbl PAY_BALANCE_BATCH_LINES_N51)
3467: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
3468: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
3469: INDEX(rr PAY_RUN_RESULTS_N50)
3470: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
3471: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */
3472: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3473: paa.assignment_action_id),16))

Line 3479: pay_run_results rr,

3475: from
3476: pay_balance_batch_lines pbl,
3477: pay_payroll_actions ppa,
3478: pay_assignment_actions paa,
3479: pay_run_results rr,
3480: pay_run_result_values rrv,
3481: pay_balance_feeds_f pbf
3482: where pbl.batch_id = p_glbl_data_rec.batch_id
3483: and pbl.assignment_id = p_glbl_data_rec.assignment_id