APPS.PAY_SA_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 17: defined_balance_id pay_defined_balances.defined_balance_id%type,

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

Line 164: FROM pay_defined_balances

160:
161: /* Cursor to fetch defined balance id */
162: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
163: SELECT defined_balance_id
164: FROM pay_defined_balances
165: WHERE balance_type_id = bal_type_id
166: AND balance_dimension_id = bal_dim_id;
167:
168: -----------------------------------------------------

Line 2215: FROM pay_defined_balances

2211:
2212: /* Cursor to fetch defined balance id */
2213: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2214: SELECT defined_balance_id
2215: FROM pay_defined_balances
2216: WHERE balance_type_id = bal_type_id
2217: AND balance_dimension_id = bal_dim_id;
2218:
2219: rec_get_balance csr_get_balance%ROWTYPE;