DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_BALANCE_ATTRIBUTES

Line 230: PAY_BALANCE_ATTRIBUTES PBA ,

226: PAC.TAX_UNIT_ID,
227: PDB.BALANCE_TYPE_ID
228: FROM
229: PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD ,
230: PAY_BALANCE_ATTRIBUTES PBA ,
231: PAY_DEFINED_BALANCES PDB ,
232: PAY_BALANCE_DIMENSIONS PBD ,
233: PAY_BALANCE_FEEDS_F PBF ,
234: PAY_INPUT_VALUES_F PIV,

Line 1285: ,pay_balance_attributes pba

1281: CURSOR c_fw_alw_bal_id IS
1282: select pbt.balance_type_id,
1283: pbt.balance_name
1284: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
1285: ,pay_balance_attributes pba
1286: ,pay_defined_balances pdb
1287: ,pay_balance_types pbt
1288: ,pay_balance_dimensions pbd
1289: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'

Line 1311: ,pay_balance_attributes pba

1307: CURSOR c_alw_bal_id IS
1308: select pbt.balance_name
1309: , pdb.defined_balance_id
1310: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
1311: ,pay_balance_attributes pba
1312: ,pay_defined_balances pdb
1313: ,pay_balance_types pbt
1314: ,pay_balance_dimensions pbd
1315: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'

Line 2431: ,pay_balance_attributes pba

2427: AND pbd.legislation_code = 'AU'
2428: AND exists (
2429: select null
2430: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2431: ,pay_balance_attributes pba
2432: ,pay_defined_balances pdb2
2433: ,pay_balance_dimensions pbd2
2434: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
2435: and pba.attribute_id = pbad.attribute_id