[Home] [Help]
87: --
88: FUNCTION get_lookup_code (p_meaning IN VARCHAR2, p_date_active IN DATE)
89: RETURN VARCHAR2
90: IS
91: l_lookup_code hr_lookups.lookup_code%TYPE;
92:
93: CURSOR get_lookup_code_cur
94: IS
95: SELECT lookup_code
92:
93: CURSOR get_lookup_code_cur
94: IS
95: SELECT lookup_code
96: FROM hr_lookups
97: WHERE meaning = p_meaning
98: AND lookup_type = 'NAME_TRANSLATIONS'
99: AND enabled_flag = 'Y'
100: AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
138: p_date_active IN DATE
139: )
140: RETURN VARCHAR2
141: IS
142: l_meaning hr_lookups.meaning%TYPE;
143:
144: CURSOR get_meaning_cur (p_code VARCHAR2, p_type VARCHAR2, p_date DATE)
145: IS
146: SELECT fcl.meaning
143:
144: CURSOR get_meaning_cur (p_code VARCHAR2, p_type VARCHAR2, p_date DATE)
145: IS
146: SELECT fcl.meaning
147: FROM hr_lookups fcl --FORMS60
148: WHERE fcl.lookup_code = p_code
149: AND fcl.lookup_type = p_type
150: AND fcl.enabled_flag = 'Y'
151: AND p_date BETWEEN NVL (fcl.start_date_active, p_date)
260: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE
261: INDEX BY BINARY_INTEGER;
262:
263: pbl_value pbl_values_table;
264: l_value_meaning hr_lookups.meaning%TYPE;
265:
266: CURSOR c_date_input_value (
267: cp_element_type_id NUMBER,
268: cp_assignment_id NUMBER,
402: -- OTM elements.
403: --
404: -- For example: In French the user must create an input value for 'Hours' to
405: -- be 'Heures' and then to determine which input value 'Heures' is associated
406: -- with we look at the hr_lookups and if we find an entry with lookup_type =
407: -- 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning to be 'Heures'
408: -- then we know that this input vale woul map to 'Hours'.
409: --
410: -- What need to be noted that it is the customer's responsibilty to create
1087: FROM hxt_timecards_x tim,
1088: per_time_periods ptp,
1089: hxt_det_hours_worked_x hrw,
1090: hxt_sum_hours_worked_x hsw,
1091: hr_lookups hcl, --GLOBAL
1092: per_assignments_f asm,
1093: pay_element_types_f elt,
1094: hxt_pay_element_types_f_ddf_v eltv, --SIR65
1095: pay_cost_allocation_keyflex pcak,
1218: hrw.zip_code
1219: FROM hxt_timecards_x tim,
1220: per_time_periods ptp,
1221: hxt_det_hours_worked_x hrw,
1222: hr_lookups hcl, --GLOBAL
1223: per_assignments_f asm,
1224: pay_element_types_f elt,
1225: pay_cost_allocation_keyflex pcak,
1226:
2648: hrw.parent_id
2649: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
2650: per_time_periods ptp,
2651: hxt_det_hours_worked_f hrw,
2652: hr_lookups hcl, --GLOBAL
2653: per_assignments_f asm,
2654: pay_element_types_f elt,
2655: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2656: pay_cost_allocation_keyflex pcak,
2743:
2744: pbl_value pbl_values_table;
2745:
2746: --END GLOBAL
2747: l_value_meaning hr_lookups.meaning%TYPE;
2748:
2749: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2750:
2751: BEGIN
2857: -- OTM elements.
2858: --
2859: -- For example: In French the user must create an input value for 'Hours' to
2860: -- be 'Heures' and then to determine which input value 'Heures' is associated
2861: -- with we look at the hr_lookups and if we find an entry with lookup_type =
2862: -- 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning to be 'Heures'
2863: -- then we know that this input vale woul map to 'Hours'.
2864: --
2865: -- What need to be noted that it is the customer's responsibilty to create
3147: /* BSE107 */
3148: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
3149: per_time_periods ptp,
3150: hxt_det_hours_worked_f hrw,
3151: hr_lookups hcl, --GLOBAL
3152: per_assignments_f asm,
3153: pay_element_types_f elt,
3154: pay_cost_allocation_keyflex pcak,
3155: