APPS.PAY_DK_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 182: FROM pay_defined_balances

178:
179: /* Cursor to fetch defined balance id */
180: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
181: SELECT defined_balance_id
182: FROM pay_defined_balances
183: WHERE balance_type_id = bal_type_id
184: AND balance_dimension_id = bal_dim_id;
185:
186: -----------------------------------------------------

Line 2175: FROM pay_defined_balances

2171: -----------------
2172: /* Cursor to fetch defined balance id */
2173: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2174: SELECT defined_balance_id
2175: FROM pay_defined_balances
2176: WHERE balance_type_id = bal_type_id
2177: AND balance_dimension_id = bal_dim_id;
2178: ----------------
2179: rec_get_balance csr_get_balance%ROWTYPE;

Line 2746: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2742: l_rec get_details%ROWTYPE;
2743: l_tax_rec csr_tax_details%ROWTYPE;
2744: l_action_info_id pay_action_information.action_information_id%TYPE;
2745: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
2746: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2747:
2748: -- Bug Fix 5081696
2749: l_global_tax_percent VARCHAR2(20);
2750: l_use_tax_card VARCHAR2(20);