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

2596: -----------------
2597: /* Cursor to fetch defined balance id */
2598: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2599: SELECT defined_balance_id
2600: FROM pay_defined_balances
2601: WHERE balance_type_id = bal_type_id
2602: AND balance_dimension_id = bal_dim_id;
2603: ----------------
2604: rec_get_balance csr_get_balance%ROWTYPE;

Line 3188: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

3184: l_rec get_details%ROWTYPE;
3185: l_tax_rec csr_tax_details%ROWTYPE;
3186: l_action_info_id pay_action_information.action_information_id%TYPE;
3187: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3188: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3189:
3190: -- Bug Fix 5081696
3191: l_global_tax_percent VARCHAR2(20);
3192: l_use_tax_card VARCHAR2(20);