DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_RUN_RESULT_VALUES

Line 3470: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)

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))
3474: into l_asg_act_id

Line 3480: pay_run_result_values rrv,

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
3484: and pbl.balance_type_id = l_lat_asg_balance.balance_type_id