APPS.PAY_AE_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 18: defined_balance_id pay_defined_balances.defined_balance_id%type,

14: ,archive_flag VARCHAR2(1));
15:
16: TYPE balance_rec IS RECORD (
17: balance_name pay_balance_types.balance_name%type,
18: defined_balance_id pay_defined_balances.defined_balance_id%type,
19: balance_type_id pay_balance_types.balance_type_id%type,
20: uom pay_input_values_f.uom%type);
21:
22: TYPE lock_rec IS RECORD (

Line 195: FROM pay_defined_balances

191:
192: /* Cursor to fetch defined balance id */
193: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
194: SELECT defined_balance_id
195: FROM pay_defined_balances
196: WHERE balance_type_id = bal_type_id
197: AND balance_dimension_id = bal_dim_id;
198:
199: --------------------------------------------------------------

Line 2193: FROM pay_defined_balances

2189:
2190: /* Cursor to fetch defined balance id */
2191: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2192: SELECT defined_balance_id
2193: FROM pay_defined_balances
2194: WHERE balance_type_id = bal_type_id
2195: AND balance_dimension_id = bal_dim_id;
2196:
2197: /* Cursor to fetch Unit of Measure */