[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';
1124: l_pgm_year_end_dt Date;
1125: --l_date_of_birth Date;
1126: l_tspc_rate_start_dt Date;
1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1128: l_pl_id ben_pl_f.pl_id%type;
1129: l_oipl_id ben_oipl_f.oipl_id%type;
1130: l_opt_name ben_opt_f.name%type;
1131:
1132:
1477: l_proc_name VARCHAR2(100);
1478: v_eligible VARCHAR2(1);
1479: v_ler_name ben_ler_f.name%type;
1480: v_opt_name ben_opt_f.name%type;
1481: v_pl_name ben_pl_f.name%type;
1482: v_person_id per_all_people_f.person_id%type;
1483: v_coe_date Date;
1484:
1485: Cursor c_get_person_id is
1501: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1502:
1503: Cursor c_get_plan_name is
1504: select name
1505: from ben_pl_f
1506: where pl_id = p_pl_id
1507: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1508:
1509: