DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 484: ,pay_defined_balances pdb

480: SELECT pdb.defined_balance_id balance_id
481: ,pbt.balance_name balance_name
482: FROM pay_balance_types pbt
483: ,pay_balance_dimensions pbd
484: ,pay_defined_balances pdb
485: WHERE pbt.balance_name IN('Employee Statutory PF Contribution'
486: ,'Employee Voluntary PF Contribution'
487: ,'Employer PF Contribution'
488: ,'EPS Contribution'

Line 517: ,pay_defined_balances pdb

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