[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):
158: l_cd_meaning_new hr_lookups.meaning%type;
159: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
162: l_person_id fnd_user.employee_id%type;
163: --
164: cursor c_per_in_ler is
165: select inf.group_per_in_ler_id
166: ,inf.group_pl_id pl_id
182: where lookup_type = v_lookup_type
183: and lookup_code = v_lookup_code;
184: --
185: cursor c_person_id
186: (l_user_id fnd_user.employee_id%type) is
187: select employee_id
188: from fnd_user
189: where user_id = l_user_id;
190: --
184: --
185: cursor c_person_id
186: (l_user_id fnd_user.employee_id%type) is
187: select employee_id
188: from fnd_user
189: where user_id = l_user_id;
190: --
191: cursor c_collect_record_rating
192: (p_assgn_id number
318: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
319: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
320: l_lang varchar2(30);
321: l_temp varchar2(30);
322: l_person_id fnd_user.employee_id%type;
323:
324: --
325: cursor c_per_in_ler is
326: select inf.group_per_in_ler_id
343: and lookup_code = v_lookup_code;
344: --
345: cursor c_person_id is
346: select employee_id
347: from fnd_user
348: where user_id = fnd_global.user_id;
349: --
350: cursor c_collect_record_promotions
351: (v_assgn_id number