[Home] [Help]
59: --
60: FUNCTION get_lookup_code (p_meaning IN VARCHAR2, p_date_active IN DATE)
61: RETURN VARCHAR2
62: IS
63: l_lookup_code hr_lookups.lookup_code%TYPE;
64:
65: CURSOR get_lookup_code_cur
66: IS
67: SELECT lookup_code
64:
65: CURSOR get_lookup_code_cur
66: IS
67: SELECT lookup_code
68: FROM hr_lookups
69: WHERE meaning = p_meaning
70: AND lookup_type = 'NAME_TRANSLATIONS'
71: AND enabled_flag = 'Y'
72: AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
110: p_date_active IN DATE
111: )
112: RETURN VARCHAR2
113: IS
114: l_meaning hr_lookups.meaning%TYPE;
115:
116: CURSOR get_meaning_cur (p_code VARCHAR2, p_type VARCHAR2, p_date DATE)
117: IS
118: SELECT fcl.meaning
115:
116: CURSOR get_meaning_cur (p_code VARCHAR2, p_type VARCHAR2, p_date DATE)
117: IS
118: SELECT fcl.meaning
119: FROM hr_lookups fcl --FORMS60
120: WHERE fcl.lookup_code = p_code
121: AND fcl.lookup_type = p_type
122: AND fcl.enabled_flag = 'Y'
123: AND p_date BETWEEN NVL (fcl.start_date_active, p_date)
225: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE
226: INDEX BY BINARY_INTEGER;
227:
228: pbl_value pbl_values_table;
229: l_value_meaning hr_lookups.meaning%TYPE;
230:
231: CURSOR c_date_input_value (
232: cp_element_type_id NUMBER,
233: cp_assignment_id NUMBER,
350: -- OTM elements.
351: --
352: -- For example: In French the user must create an input value for 'Hours' to
353: -- be 'Heures' and then to determine which input value 'Heures' is associated
354: -- with we look at the hr_lookups and if we find an entry with lookup_type =
355: -- 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning to be 'Heures'
356: -- then we know that this input vale woul map to 'Hours'.
357: --
358: -- What need to be noted that it is the customer's responsibilty to create
842: hrw.zip_code
843: FROM hxt_timecards_x tim,
844: per_time_periods ptp,
845: hxt_det_hours_worked_x hrw,
846: hr_lookups hcl, --GLOBAL
847: per_assignments_f asm,
848: pay_element_types_f elt,
849: hxt_pay_element_types_f_ddf_v eltv, --SIR65
850: pay_cost_allocation_keyflex pcak,
974: hrw.zip_code
975: FROM hxt_timecards_x tim,
976: per_time_periods ptp,
977: hxt_det_hours_worked_x hrw,
978: hr_lookups hcl, --GLOBAL
979: per_assignments_f asm,
980: pay_element_types_f elt,
981: pay_cost_allocation_keyflex pcak,
982:
2270: hrw.zip_code
2271: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
2272: per_time_periods ptp,
2273: hxt_det_hours_worked_f hrw,
2274: hr_lookups hcl, --GLOBAL
2275: per_assignments_f asm,
2276: pay_element_types_f elt,
2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2278: pay_cost_allocation_keyflex pcak,
2365:
2366: pbl_value pbl_values_table;
2367:
2368: --END GLOBAL
2369: l_value_meaning hr_lookups.meaning%TYPE;
2370:
2371: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2372:
2373: BEGIN
2474: -- OTM elements.
2475: --
2476: -- For example: In French the user must create an input value for 'Hours' to
2477: -- be 'Heures' and then to determine which input value 'Heures' is associated
2478: -- with we look at the hr_lookups and if we find an entry with lookup_type =
2479: -- 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning to be 'Heures'
2480: -- then we know that this input vale woul map to 'Hours'.
2481: --
2482: -- What need to be noted that it is the customer's responsibilty to create
2751: /* BSE107 */
2752: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
2753: per_time_periods ptp,
2754: hxt_det_hours_worked_f hrw,
2755: hr_lookups hcl, --GLOBAL
2756: per_assignments_f asm,
2757: pay_element_types_f elt,
2758: pay_cost_allocation_keyflex pcak,
2759: