DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 2029: ,pay_defined_balances pdb

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'
2033: and pbd.legislation_code = 'IN'

Line 2702: ,pay_defined_balances pdb

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'
2706: AND pbd.legislation_code = 'IN'