DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 229: PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD ,

225: PEE.ASSIGNMENT_ID ASSIGNMENT_ID,
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 ,

Line 1284: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

1280:
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

Line 1310: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

1306: /* start bug 7571001 - new cursor c_alw_bal_id is added */
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

Line 2430: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

2426: AND pdb.business_group_id = p_business_group_id
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'