DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 1880: ,pay_defined_balances pdb

1876: IS
1877: select pdb.defined_balance_id
1878: from pay_balance_types pbt
1879: ,pay_balance_dimensions pbd
1880: ,pay_defined_balances pdb
1881: where pbt.balance_name=p_balance_name
1882: and pbd.dimension_name=p_dimension
1883: and pbt.legislation_code = 'IN'
1884: and pbd.legislation_code = 'IN'

Line 2490: ,pay_defined_balances pdb

2486: IS
2487: SELECT pdb.defined_balance_id
2488: FROM pay_balance_types pbt
2489: ,pay_balance_dimensions pbd
2490: ,pay_defined_balances pdb
2491: WHERE pbt.balance_name=p_balance_name
2492: AND pbd.dimension_name=p_dimension
2493: AND pbt.legislation_code = 'IN'
2494: AND pbd.legislation_code = 'IN'