APPS.PAY_ADHOC_UTILS_PKG dependencies on PAY_BALANCE_VALIDATION

Line 856: FROM pay_balance_validation pbv

852:
853: --To get the balance load date from single defined_balance_id
854: CURSOR get_balance_date IS
855: SELECT pbv.balance_load_date
856: FROM pay_balance_validation pbv
857: WHERE pbv.business_group_id = p_business_group_id
858: AND pbv.defined_balance_id = p_defined_balance_id
859: AND pbv.run_balance_status = 'V' ;
860:

Line 867: FROM pay_balance_validation pbv,

863: CURSOR get_attribute_bal_date(c_attribute_name VARCHAR2,
864: c_business_group_id NUMBER,
865: c_database_item_suffix VARCHAR2) IS
866: SELECT max(balance_load_date) balance_load_date
867: FROM pay_balance_validation pbv,
868: pay_balance_attributes pba,
869: pay_bal_attribute_definitions pbad,
870: pay_defined_balances pdb,
871: pay_balance_dimensions pbd