APPS.PAY_PAYGTN_PKG dependencies on PAY_BALANCE_TYPES

Line 683: pay_balance_types pbt,

679:
680: cursor get_futa_def_bal_id(cp_business_group_id number) is
681: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
682: FROM pay_defined_balances pdb,
683: pay_balance_types pbt,
684: pay_balance_dimensions pbd
685: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
686: AND pdb.balance_type_id = pbt.balance_type_id
687: AND ( pdb.business_group_id = cp_business_group_id

Line 707: pay_balance_types pbt,

703: cursor c_wc_er_liab_valid_count(cp_business_group_id number,cp_start_date date) IS
704: select count(*)
705: from pay_balance_validation pbv,
706: pay_defined_balances pdb,
707: pay_balance_types pbt,
708: pay_balance_dimensions pbd
709: where (pbv.business_group_id = cp_business_group_id)
710: and pbv.defined_balance_id = pdb.defined_balance_id
711: and pdb.balance_dimension_id = pbd.balance_dimension_id