[Home] [Help]
888: and element_set_type = 'C';
889:
890: cursor cur_ele_element_class is
891: select classification_name
892: from pay_element_classifications
893: where classification_id = to_number(p_ele_element_class);
894:
895: cursor cur_ele_element_name is
896: select element_name
906: between effective_start_date and effective_end_date;
907:
908: cursor cur_ded_class is
909: select classification_name
910: from pay_element_classifications
911: where classification_id = to_number(p_deduction_class);
912:
913: cursor cur_ded_name is
914: select element_name
1000: and element_set_type = 'C';
1001:
1002: cursor cur_costing_detail_ele_class is
1003: select classification_name
1004: from pay_element_classifications
1005: where classification_id = to_number(p_cost_detail_class);
1006:
1007: cursor cur_costing_detail_ele_name is
1008: select tl.element_name
3017: and element_set_type = 'C';
3018:
3019: cursor cur_ele_element_class is
3020: select classification_name
3021: from pay_element_classifications
3022: where classification_id = to_number(p_ele_element_class);
3023:
3024: cursor cur_ele_element_name is
3025: select element_name
3035: between effective_start_date and effective_end_date;
3036:
3037: cursor cur_ded_class is
3038: select classification_name
3039: from pay_element_classifications
3040: where classification_id = to_number(p_deduction_class);
3041:
3042: cursor cur_ded_name is
3043: select element_name
3129: and element_set_type = 'C';
3130:
3131: cursor cur_costing_detail_ele_class is
3132: select classification_name
3133: from pay_element_classifications
3134: where classification_id = to_number(p_cost_detail_class);
3135:
3136: cursor cur_costing_detail_ele_name is
3137: select tl.element_name