[Home] [Help]
37: * Adding exception block to select stmts.
38: * 115.14 03-Jan-2005 steotia Bug 4083398 - no data found correction
39: * 115.16 07-Jan-2005 steotia Added SCL audit event for promotions.
40: * Corrected cursor for promotions.
41: * 115.17 11-Jan-2005 steotia Writing fnd_user.employee_id
42: * 115.18 02-Feb-2005 steotia Bug 4150327
43: * 115.19 10-Feb-2005 maagrawa Pass group_pl_id as plan reference to
44: * process_rating, process_promotions.
45: * 115.20 20-Feb-2005 steotia Performance improvement(audit):
163: l_cd_meaning_new hr_lookups.meaning%type;
164: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
167: l_person_id fnd_user.employee_id%type;
168: --
169: cursor c_per_in_ler is
170: select inf.group_per_in_ler_id
171: ,inf.group_pl_id pl_id
187: where lookup_type = v_lookup_type
188: and lookup_code = v_lookup_code;
189: --
190: cursor c_person_id
191: (l_user_id fnd_user.employee_id%type) is
192: select employee_id
193: from fnd_user
194: where user_id = l_user_id;
195: --
189: --
190: cursor c_person_id
191: (l_user_id fnd_user.employee_id%type) is
192: select employee_id
193: from fnd_user
194: where user_id = l_user_id;
195: --
196: cursor c_collect_record_rating
197: (p_assgn_id number
323: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
324: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
325: l_lang varchar2(30);
326: l_temp varchar2(30);
327: l_person_id fnd_user.employee_id%type;
328:
329: --
330: cursor c_per_in_ler is
331: select inf.group_per_in_ler_id
348: and lookup_code = v_lookup_code;
349: --
350: cursor c_person_id is
351: select employee_id
352: from fnd_user
353: where user_id = fnd_global.user_id;
354: --
355: cursor c_collect_record_promotions
356: (v_assgn_id number