APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 621: , pay_balance_types pbt

617: cursor c_get_def_bal_id is
618: select pdb.defined_balance_id
619: from pay_balance_dimensions pbd
620: , pay_defined_balances pdb
621: , pay_balance_types pbt
622: where pbd.dimension_name = p_dim_name
623: and pbd.legislation_code = 'ZA'
624: and pdb.balance_type_id = pbt.balance_type_id
625: and pbt.balance_name = p_bal_name