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 2257: FROM pay_defined_balances

2253: WHERE paa.assignment_action_id = p_run_assact_id;
2254: /* Cursor to fetch defined balance id */
2255: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2256: SELECT defined_balance_id
2257: FROM pay_defined_balances
2258: WHERE balance_type_id = bal_type_id
2259: AND balance_dimension_id = bal_dim_id;
2260: rec_get_balance csr_get_balance%ROWTYPE;
2261: l_balance_value NUMBER := 0;

Line 2453: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2449: l_rec get_details%ROWTYPE;
2450: l_tax_rec csr_tax_details%ROWTYPE;
2451: l_action_info_id pay_action_information.action_information_id%TYPE;
2452:
2453: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2454:
2455:
2456: BEGIN
2457: