DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PER_PAY_BASES

Line 560: FROM PER_PAY_BASES pb,

556: --
557: pel.pay_basis_id is null and
558: NOT EXISTS
559: (SELECT pb.pay_basis_id
560: FROM PER_PAY_BASES pb,
561: PAY_INPUT_VALUES_F iv
562: WHERE iv.element_type_id = pel.element_type_id
563: and P_REFLECTION_DATE between
564: iv.effective_start_date and iv.effective_end_date

Line 577: FROM PER_PAY_BASES pb,

573: --
574: pel.pay_basis_id is null and
575: EXISTS
576: (SELECT pb.pay_basis_id
577: FROM PER_PAY_BASES pb,
578: PAY_INPUT_VALUES_F iv
579: WHERE iv.element_type_id = pel.element_type_id
580: and P_REFLECTION_DATE between
581: iv.effective_start_date and iv.effective_end_date

Line 591: FROM PER_PAY_BASES pb,

587: pel.pay_basis_id is null and
588: asg.pay_basis_id is null and
589: EXISTS
590: (SELECT pb.pay_basis_id
591: FROM PER_PAY_BASES pb,
592: PAY_INPUT_VALUES_F iv
593: WHERE iv.element_type_id = pel.element_type_id
594: and P_REFLECTION_DATE between
595: iv.effective_start_date and iv.effective_end_date