APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 151: FROM pay_defined_balances

147: AND org_information1 = 'BALANCE';
148: /* Cursor to fetch defined balance id */
149: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
150: SELECT defined_balance_id
151: FROM pay_defined_balances
152: WHERE balance_type_id = bal_type_id
153: AND balance_dimension_id = bal_dim_id;
154: -----------------------------------------------------
155: --ELEMENTS

Line 2269: FROM pay_defined_balances

2265: WHERE paa.assignment_action_id = p_run_assact_id;
2266: /* Cursor to fetch defined balance id */
2267: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2268: SELECT defined_balance_id
2269: FROM pay_defined_balances
2270: WHERE balance_type_id = bal_type_id
2271: AND balance_dimension_id = bal_dim_id;
2272: rec_get_balance csr_get_balance%ROWTYPE;
2273: l_balance_value NUMBER := 0;

Line 2465: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2461: l_rec get_details%ROWTYPE;
2462: l_tax_rec csr_tax_details%ROWTYPE;
2463: l_action_info_id pay_action_information.action_information_id%TYPE;
2464:
2465: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2466:
2467:
2468: BEGIN
2469: