APPS.PAY_AE_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 17: balance_name pay_balance_types.balance_name%type,

13: ,uom pay_input_values_f.uom%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:

Line 19: balance_type_id pay_balance_types.balance_type_id%type,

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 (
23: archive_assact_id NUMBER);

Line 2200: FROM pay_balance_types

2196:
2197: /* Cursor to fetch Unit of Measure */
2198: CURSOR csr_uom(bal_type_id NUMBER) IS
2199: SELECT balance_uom
2200: FROM pay_balance_types
2201: WHERE balance_type_id = bal_type_id;
2202:
2203: rec_get_balance csr_get_balance%ROWTYPE;
2204: l_balance_value NUMBER := 0;