APPS.PAY_PAYGTN_PKG dependencies on PAY_BALANCE_TYPES

Line 692: pay_balance_types pbt,

688:
689: cursor get_futa_def_bal_id(cp_business_group_id number) is
690: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
691: FROM pay_defined_balances pdb,
692: pay_balance_types pbt,
693: pay_balance_dimensions pbd
694: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
695: AND pdb.balance_type_id = pbt.balance_type_id
696: AND ( pdb.business_group_id = cp_business_group_id

Line 716: pay_balance_types pbt,

712: cursor c_wc_er_liab_valid_count(cp_business_group_id number,cp_start_date date) IS
713: select count(*)
714: from pay_balance_validation pbv,
715: pay_defined_balances pdb,
716: pay_balance_types pbt,
717: pay_balance_dimensions pbd
718: where (pbv.business_group_id = cp_business_group_id)
719: and pbv.defined_balance_id = pdb.defined_balance_id
720: and pdb.balance_dimension_id = pbd.balance_dimension_id