DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on PER_PAY_BASES

Line 609: FROM PER_PAY_BASES pb,

605: --
606: pel.pay_basis_id is null and
607: NOT EXISTS
608: (SELECT pb.pay_basis_id
609: FROM PER_PAY_BASES pb,
610: PAY_INPUT_VALUES_F iv
611: WHERE iv.element_type_id = pel.element_type_id
612: and p_effective_date between
613: iv.effective_start_date and iv.effective_end_date

Line 626: FROM PER_PAY_BASES pb,

622: --
623: pel.pay_basis_id is null and
624: EXISTS
625: (SELECT pb.pay_basis_id
626: FROM PER_PAY_BASES pb,
627: PAY_INPUT_VALUES_F iv
628: WHERE iv.element_type_id = pel.element_type_id
629: and p_effective_date between
630: iv.effective_start_date and iv.effective_end_date

Line 641: FROM PER_PAY_BASES pb,

637: pel.pay_basis_id is null and
638: asg.pay_basis_id is null and
639: EXISTS
640: (SELECT pb.pay_basis_id
641: FROM PER_PAY_BASES pb,
642: PAY_INPUT_VALUES_F iv
643: WHERE iv.element_type_id = pel.element_type_id
644: and p_effective_date between
645: iv.effective_start_date and iv.effective_end_date