DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 1879: ,pay_balance_dimensions pbd

1875: ,p_dimension VARCHAR2)
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'

Line 2489: ,pay_balance_dimensions pbd

2485: ,p_dimension VARCHAR2)
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'