DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 486: FROM pay_balance_types pbt

482: CURSOR csr_pf_balances
483: IS
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'

Line 519: FROM pay_balance_types pbt

515: CURSOR csr_pf_balances_ptd
516: IS
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'