DBA Data[Home] [Help]

APPS.PAY_ADHOC_UTILS_PKG dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 817: pay_bal_attribute_definitions pbad

813: c_business_group_id NUMBER,
814: c_attribute_name VARCHAR2) is
815: SELECT pba.defined_balance_id
816: FROM pay_balance_attributes pba,
817: pay_bal_attribute_definitions pbad
818: WHERE pba.attribute_id = pbad.attribute_id
819: AND pba.defined_balance_id = c_defined_balance_id
820: AND pbad.attribute_name = c_attribute_name
821: AND ((pba.business_group_id = c_business_group_id and pba.legislation_code is null) or

Line 869: pay_bal_attribute_definitions pbad,

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
872: WHERE pbv.defined_balance_id = pdb.defined_balance_id
873: AND pdb.defined_balance_id = pba.defined_balance_id