[Home] [Help]
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
658: and pb.input_value_id =
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
675: and pb.input_value_id =
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
690: and pb.input_value_id =
2579: into v_uom,
2580: v_hot_default_flag,
2581: v_lookup_type,
2582: v_value_set_id
2583: from pay_input_values_f iv
2584: where iv.input_value_id = p_input_value_id
2585: and p_session_date
2586: between iv.effective_start_date and iv.effective_end_date;
2587: exception
2636: '',i.default_value,
2637: l.default_value)
2638: into v_default_value
2639: from pay_link_input_values_f l,
2640: pay_input_values_f i
2641: where i.input_value_id = p_input_value_id
2642: and l.input_value_id = i.input_value_id
2643: and l.element_link_id = p_element_link_id
2644: and p_session_date
2663: i.max_value
2664: into v_default_value,
2665: v_minimum_value,
2666: v_maximum_value
2667: from pay_input_values_f i
2668: where i.input_value_id = p_input_value_id
2669: and p_session_date
2670: between i.effective_start_date and i.effective_end_date;
2671: exception
2805: i_tl.name
2806: into v_hot_default_flag,
2807: v_mandatory_flag,
2808: v_name
2809: from pay_input_values_f_tl i_tl,
2810: pay_input_values_f i
2811: where i.input_value_id = i_tl.input_value_id
2812: and i.input_value_id = p_input_value_id
2813: and userenv('LANG') = i_tl.language
2806: into v_hot_default_flag,
2807: v_mandatory_flag,
2808: v_name
2809: from pay_input_values_f_tl i_tl,
2810: pay_input_values_f i
2811: where i.input_value_id = i_tl.input_value_id
2812: and i.input_value_id = p_input_value_id
2813: and userenv('LANG') = i_tl.language
2814: and p_session_date
2843: begin
2844: select nvl(l.default_value,i.default_value)
2845: into v_default_value
2846: from pay_link_input_values_f l,
2847: pay_input_values_f i
2848: where i.input_value_id = p_input_value_id
2849: and l.input_value_id = i.input_value_id
2850: and l.element_link_id = p_element_link_id
2851: and p_session_date
3091: -- Should not allow these absence elements for CWKs
3092: select 'Y'
3093: from pay_element_links_f pel
3094: ,pay_element_types_f pet
3095: ,pay_input_values_f piv
3096: ,per_absence_attendance_types abt
3097: where pel.element_link_id = p_element_link_id
3098: and p_session_date between pel.effective_start_date
3099: and pel.effective_end_date
3796: p_session_date date ) is
3797: select peev.input_value_id,
3798: piv.uom,
3799: peev.screen_entry_value value
3800: from pay_input_values_f piv,
3801: pay_element_entry_values_f peev
3802: where peev.element_entry_id = p_element_entry_id
3803: and piv.input_value_id = peev.input_value_id
3804: and p_session_date between peev.effective_start_date
4039: begin
4040: select eev.screen_entry_value
4041: into v_jurisdiction
4042: from pay_element_entry_values_f eev,
4043: pay_input_values_f piv,
4044: pay_element_entries_f pee
4045: where pee.element_entry_id = v_element_entry_id
4046: and eev.element_entry_id = pee.element_entry_id
4047: and eev.input_value_id = piv.input_value_id
5444: v_minimum_value,
5445: v_maximum_value,
5446: v_warning_or_error
5447: from pay_link_input_values_f liv,
5448: pay_input_values_f iv,
5449: pay_element_types_f et
5450: where liv.element_link_id = p_element_link_id
5451: and liv.input_value_id = p_input_value_id
5452: and iv.input_value_id = liv.input_value_id