APPS.PAY_PAYGTN_PKG dependencies on PAY_BALANCE_VALIDATION

Line 706: from pay_balance_validation pbv

702: AND pbt.balance_name = 'FUTA CREDIT';
703:
704: cursor chk_futa_status(cp_business_group_id number,cp_start_date date,cp_defined_balance_id number) IS
705: select count(*)
706: from pay_balance_validation pbv
707: where pbv.business_group_id = cp_business_group_id
708: and pbv.defined_balance_id = cp_defined_balance_id
709: AND NVL (pbv.run_balance_status, 'I') = 'V'
710: and NVL(pbv.balance_load_date, cp_start_date) <= cp_start_date;

Line 714: from pay_balance_validation pbv,

710: and NVL(pbv.balance_load_date, cp_start_date) <= cp_start_date;
711:
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)