APPS.PAY_EBRA_DIAGNOSTICS dependencies on PAY_BALANCE_VALIDATION

Line 365: pay_balance_validation pbv

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)
369: and pba.defined_balance_id = pbv.defined_balance_id

Line 682: , pay_balance_validation pbv

678: FROM
679: pay_defined_balances pdb, pay_balance_types pbt
680: , pay_balance_dimensions pbd
681: , per_business_groups pbg, hr_lookups hl
682: , pay_balance_validation pbv
683: , hr_lookups hl2
684: WHERE pdb.balance_type_id = pbt.balance_type_id
685: AND pdb.balance_dimension_id = pbd.balance_dimension_id
686: AND pdb.save_run_balance = 'Y'

Line 716: PAY_BALANCE_VALIDATION PBV

712: IS
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

Line 760: or not found in PAY_BALANCE_VALIDATIONS

756:
757: /**************************************************************
758: Cursor for : Find if the Balance is in Attribute but
759: Does not have save run Balancei
760: or not found in PAY_BALANCE_VALIDATIONS
761: Parameter for the Cursor :
762: cp_attribute_id : attribute_id
763: cp_business_group_id : business_group_id
764: Returns

Line 793: (select 1 from pay_balance_validation PBV

789: and ((pba.business_group_id = cp_business_group_id and pba.legislation_code is NULL) OR
790: (pba.legislation_code = cp_legislation_code and pba.business_group_id is NULL))
791: and nvl(bad.legislation_code, cp_legislation_code) = cp_legislation_Code
792: /* and not Exists
793: (select 1 from pay_balance_validation PBV
794: where PBV.defined_balance_id = PBA.defined_balance_id
795: )*/
796: order by bad.attribute_name;
797: