DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on PER_PAY_BASES

Line 653: FROM PER_PAY_BASES pb,

649: --
650: pel.pay_basis_id is null and
651: NOT EXISTS
652: (SELECT pb.pay_basis_id
653: FROM PER_PAY_BASES pb,
654: PAY_INPUT_VALUES_F iv
655: WHERE iv.element_type_id = pel.element_type_id
656: and p_effective_date between
657: iv.effective_start_date and iv.effective_end_date

Line 670: FROM PER_PAY_BASES pb,

666: --
667: pel.pay_basis_id is null and
668: EXISTS
669: (SELECT pb.pay_basis_id
670: FROM PER_PAY_BASES pb,
671: PAY_INPUT_VALUES_F iv
672: WHERE iv.element_type_id = pel.element_type_id
673: and p_effective_date between
674: iv.effective_start_date and iv.effective_end_date

Line 685: FROM PER_PAY_BASES pb,

681: pel.pay_basis_id is null and
682: asg.pay_basis_id is null and
683: EXISTS
684: (SELECT pb.pay_basis_id
685: FROM PER_PAY_BASES pb,
686: PAY_INPUT_VALUES_F iv
687: WHERE iv.element_type_id = pel.element_type_id
688: and p_effective_date between
689: iv.effective_start_date and iv.effective_end_date