DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_DEFINED_BALANCES

Line 4362: , pay_defined_balances pdb

4358: IS
4359: select pdb.defined_balance_id defined_balance_id
4360: from pay_balance_types pbt
4361: , pay_balance_dimensions pbd
4362: , pay_defined_balances pdb
4363: where pbt.balance_name = p_bal_name
4364: and pbd.database_item_suffix = '_ASG_LE_PTD'
4365: and pbt.balance_type_id = pdb.balance_type_id
4366: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 4394: pay_defined_balances pdb,

4390: , 'Foreign Lump Sum A Payments',21
4391: ) sort_index,
4392: pdb.defined_balance_id def_bal_id
4393: FROM pay_balance_types pbt,
4394: pay_defined_balances pdb,
4395: pay_balance_dimensions pbd
4396: WHERE pbt.legislation_code = 'AU'
4397: AND pdb.balance_type_id = pbt.balance_type_id
4398: AND pdb.balance_dimension_id = pbd.balance_dimension_id