DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PAY_BALANCE_TYPES

Line 1091: FROM pay_balance_types PBT

1087: --
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'

Line 1102: FROM pay_balance_types PBT

1098: --
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'