[Home] [Help]
140: hr_utility.trace('v_location id = ' ||v_location_id );
141:
142: /* get plan short code */
143: select short_code into v_plan_short_code
144: from ben_pl_f
145: where pl_id = p_pl_id
146: and p_effective_date between effective_start_date and effective_end_date;
147:
148: hr_utility.set_location(l_procedure_name,30);
276: ,p_effective_date in Date
277: ,p_pl_id in Number)
278: RETURN varchar2 is
279:
280: v_pln_short_code ben_pl_f.short_code%type;
281: l_procedure_name varchar2(100);
282:
283: Cursor C1 is
284: select short_code from ben_pl_f
280: v_pln_short_code ben_pl_f.short_code%type;
281: l_procedure_name varchar2(100);
282:
283: Cursor C1 is
284: select short_code from ben_pl_f
285: where pl_id = p_pl_id
286: and p_effective_date between effective_start_date and effective_end_date;
287: Begin
288: l_procedure_name := g_package || 'get_plan_short_code';
1128: l_pgm_year_end_dt Date;
1129: --l_date_of_birth Date;
1130: l_tspc_rate_start_dt Date;
1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1132: l_pl_id ben_pl_f.pl_id%type;
1133: l_oipl_id ben_oipl_f.oipl_id%type;
1134: l_opt_name ben_opt_f.name%type;
1135:
1136:
1481: l_proc_name VARCHAR2(100);
1482: v_eligible VARCHAR2(1);
1483: v_ler_name ben_ler_f.name%type;
1484: v_opt_name ben_opt_f.name%type;
1485: v_pl_name ben_pl_f.name%type;
1486: v_person_id per_all_people_f.person_id%type;
1487: v_coe_date Date;
1488:
1489: Cursor c_get_person_id is
1505: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1506:
1507: Cursor c_get_plan_name is
1508: select name
1509: from ben_pl_f
1510: where pl_id = p_pl_id
1511: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1512:
1513: