DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 2028: ,pay_balance_dimensions pbd

2024: ,p_dimension VARCHAR2)
2025: IS
2026: select pdb.defined_balance_id
2027: from pay_balance_types pbt
2028: ,pay_balance_dimensions pbd
2029: ,pay_defined_balances pdb
2030: where pbt.balance_name=p_balance_name
2031: and pbd.dimension_name=p_dimension
2032: and pbt.legislation_code = 'IN'

Line 2701: ,pay_balance_dimensions pbd

2697: ,p_dimension VARCHAR2)
2698: IS
2699: SELECT pdb.defined_balance_id
2700: FROM pay_balance_types pbt
2701: ,pay_balance_dimensions pbd
2702: ,pay_defined_balances pdb
2703: WHERE pbt.balance_name=p_balance_name
2704: AND pbd.dimension_name=p_dimension
2705: AND pbt.legislation_code = 'IN'