DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 488: ,pay_defined_balances pdb

484: SELECT pdb.defined_balance_id balance_id
485: ,pbt.balance_name balance_name
486: FROM pay_balance_types pbt
487: ,pay_balance_dimensions pbd
488: ,pay_defined_balances pdb
489: WHERE pbt.balance_name IN('Employee Statutory PF Contribution'
490: ,'Employee Voluntary PF Contribution'
491: ,'Employer PF Contribution'
492: ,'EPS Contribution'

Line 521: ,pay_defined_balances pdb

517: SELECT pdb.defined_balance_id balance_id
518: ,pbt.balance_name balance_name
519: FROM pay_balance_types pbt
520: ,pay_balance_dimensions pbd
521: ,pay_defined_balances pdb
522: WHERE pbt.balance_name IN('Non Contributory Period')
523: AND pbd.dimension_name ='_ASG_PTD'
524: AND pbt.legislation_code = 'IN'
525: AND pbd.legislation_code = 'IN'