APPS.PAY_EBRA_DIAGNOSTICS dependencies on PAY_BALANCE_ATTRIBUTES

Line 364: pay_balance_attributes pba,

360: cp_business_group_id in per_business_groups.business_group_id%type,
361: cp_attribute_id in number) IS
362: select /*+ ORDERED */ count(*)
363: from
364: pay_balance_attributes pba,
365: pay_balance_validation pbv
366: where pba.attribute_id = cp_attribute_id
367: and (pba.business_group_id = cp_business_group_id
368: or pba.legislation_code = p_legislation_code)

Line 379: pay_balance_attributes pba

375: cp_business_group_id in per_business_groups.business_group_id%type) IS
376:
377: select count(*)
378: from
379: pay_balance_attributes pba
380: where pba.attribute_id = cp_attribute_id
381: and (pba.business_group_id = cp_business_group_id
382: or pba.legislation_code = p_legislation_code);
383:

Line 717: ,PAY_BALANCE_ATTRIBUTES PBA

713: select distinct pba.attribute_id,
714: max(balance_load_date)
715: FROM
716: PAY_BALANCE_VALIDATION PBV
717: ,PAY_BALANCE_ATTRIBUTES PBA
718: WHERE
719: PBV.business_group_id = cp_business_group_id
720: AND PBA.attribute_id = cp_attribute_id
721: AND PBV.defined_balance_id = pba.defined_balance_id

Line 748: , PAY_BALANCE_ATTRIBUTES PBA

744: FROM
745: PAY_BALANCE_DIMENSIONS DIM
746: , PAY_BALANCE_TYPES PBT
747: , PAY_DEFINED_BALANCES PDB
748: , PAY_BALANCE_ATTRIBUTES PBA
749: WHERE
750: PBA.attribute_id = cp_attribute_id
751: and PBA.defined_balance_id = PDB.defined_balance_id
752: and PDB.balance_type_id = PBT.balance_type_id

Line 779: PAY_BALANCE_ATTRIBUTES PBA

775: ,PBT.balance_name
776: ,DIM.DIMENSION_NAME
777: ,PDB.save_run_balance
778: FROM
779: PAY_BALANCE_ATTRIBUTES PBA
780: , PAY_BAL_ATTRIBUTE_DEFINITIONS BAD
781: , PAY_DEFINED_BALANCES PDB
782: , PAY_BALANCE_TYPES PBT
783: , PAY_BALANCE_DIMENSIONS DIM