DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_FEEDS_F

Line 3764: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */

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))
3767: into l_asg_act_id
3768: from

Line 3774: pay_balance_feeds_f pbf

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
3777: and pbl.balance_type_id = l_lat_asg_balance.balance_type_id
3778: and pbl.payroll_action_id = ppa.payroll_action_id

Line 4536: ,pay_balance_feeds_f BF

4532: ,decode(nvl(BT.jurisdiction_level, 0),
4533: 0, null,
4534: IV2.input_value_id) jc_input_value_id
4535: from pay_balance_types BT
4536: ,pay_balance_feeds_f BF
4537: ,pay_input_values_f IV
4538: ,pay_input_values_f IV2
4539: ,pay_element_types_f ET
4540: ,pay_element_classifications EC