DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 1092: ,pay_balance_dimensions PBD

1088: CURSOR lcu_get_bal_id
1089: IS
1090: SELECT PDB.defined_balance_id
1091: FROM pay_balance_types PBT
1092: ,pay_balance_dimensions PBD
1093: ,pay_defined_balances PDB
1094: WHERE PBT.balance_name = 'B_TRM_INCOME_EXM'
1095: AND PBD.database_item_suffix = '_ASG_RUN'
1096: AND PBT.balance_type_id = PDB.balance_type_id

Line 1103: ,pay_balance_dimensions PBD

1099: CURSOR get_bal_id_spc
1100: IS
1101: SELECT PDB.defined_balance_id
1102: FROM pay_balance_types PBT
1103: ,pay_balance_dimensions PBD
1104: ,pay_defined_balances PDB
1105: WHERE PBT.balance_name = 'B_TRM_INC_DEDN_SPC_EXC'
1106: AND PBD.database_item_suffix = '_ASG_RUN'
1107: AND PBT.balance_type_id = PDB.balance_type_id