DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_DEDUCTIONS_RBR_V

Line 2639: from pay_us_deductions_rbr_v

2635: select ytd_val,
2636: reporting_name_alt,
2637: run_val,
2638: element_type_id
2639: from pay_us_deductions_rbr_v
2640: where assignment_action_id = c_run_assact_id
2641: order by reporting_name_alt;
2642:
2643: -- Cursor to get run values of tax deductions when balances are valid

Line 2648: from pay_us_deductions_rbr_v pt

2644: CURSOR c_get_dedn_run_rb(cp_run_action_id number) IS
2645: select reporting_name_alt,
2646: run_val,
2647: element_type_id
2648: from pay_us_deductions_rbr_v pt
2649: where pt.assignment_action_id = cp_run_action_id
2650: order by reporting_name_alt;
2651:
2652: -- Cursor to get ytd values of tax deductions when balances are valid for master action

Line 2657: from pay_us_deductions_rbr_v pt

2653: CURSOR c_get_dedn_ytd_rb(cp_master_action_id number) IS
2654: select ytd_val,
2655: reporting_name_alt,
2656: element_type_id
2657: from pay_us_deductions_rbr_v pt
2658: where pt.assignment_action_id = cp_master_action_id;
2659:
2660:
2661: -- Cursor to other deduction elements from element entries