DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PAY_DEFINED_BALANCES

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

2103:
2104: /* Cursor to fetch defined balance id */
2105: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2106: SELECT defined_balance_id
2107: FROM pay_defined_balances
2108: WHERE balance_type_id = bal_type_id
2109: AND balance_dimension_id = bal_dim_id;
2110:
2111: rec_get_balance csr_get_balance%ROWTYPE;