eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PAY_INPUT_VALUES_F

Line 127: , pay_input_values_f piv

123: cursor c_get_ele_dtls is
124: select pet.element_type_id
125: , piv.input_value_id
126: from pay_element_types_f pet
127: , pay_input_values_f piv
128: where pet.element_name = p_element_name
129: and p_effective_date between pet.effective_start_date
130: and pet.effective_end_date
131: and piv.element_type_id = pet.element_type_id

Line 561: PAY_INPUT_VALUES_F iv

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
565: and pb.input_value_id =

Line 578: PAY_INPUT_VALUES_F iv

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
582: and pb.input_value_id =

Line 592: PAY_INPUT_VALUES_F iv

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
596: and pb.input_value_id =