DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 482: FROM pay_balance_types pbt

478: CURSOR csr_pf_balances
479: IS
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'

Line 515: FROM pay_balance_types pbt

511: CURSOR csr_pf_balances_ptd
512: IS
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'