[Home] [Help]
169: l_pgm_id ben_pgm_f.pgm_id%type;
170: l_pl_id ben_pl_f.pl_id%type;
171: l_opt_id ben_opt_f.opt_id%type;
172: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
173: l_plip_id ben_plip_f.plip_id%type;
174: l_oipl_id ben_oipl_f.oipl_id%type;
175: l_ler_id ben_ler_f.ler_id%type;
176: l_ptip_id ben_ptip_f.ptip_id%type;
177: l_exists boolean;
260:
261: --Cursor to get the plan in Program Id for the given Pl_id
262: Cursor get_plip_id is
263: select plip.plip_id
264: from ben_plip_f plip
265: where plip.pl_id = l_pl_id
266: and plip.pgm_id = l_pgm_id
267: and plip.business_group_id = p_business_group_id
268: and p_effective_date between effective_start_date and effective_end_date;
702: l_pgm_id ben_pgm_f.pgm_id%type;
703: l_pl_id ben_pl_f.pl_id%type;
704: l_opt_id ben_opt_f.opt_id%type;
705: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
706: l_plip_id ben_plip_f.plip_id%type;
707: l_oipl_id ben_oipl_f.oipl_id%type;
708: l_ler_id ben_ler_f.ler_id%type;
709: l_ptip_id ben_ptip_f.ptip_id%type;
710: l_assignment_id per_all_assignments_f.assignment_id%type;
773:
774: --Cursor to get the plan in Program Id for the given Pl_id
775: Cursor c_get_plip_id is
776: select plip.plip_id
777: from ben_plip_f plip
778: where plip.pl_id = l_pl_id
779: and plip.pgm_id = l_pgm_id
780: and plip.business_group_id = p_business_group_id;
781:
1059: l_pgm_id ben_pgm_f.pgm_id%type;
1060: l_pl_id ben_pl_f.pl_id%type;
1061: l_opt_id ben_opt_f.opt_id%type;
1062: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1063: l_plip_id ben_plip_f.plip_id%type;
1064: l_oipl_id ben_oipl_f.oipl_id%type;
1065: l_ler_id ben_ler_f.ler_id%type;
1066: l_ptip_id ben_ptip_f.ptip_id%type;
1067: l_exists boolean;
1129:
1130: --Cursor to get the plan in Program Id for the given Pl_id
1131: Cursor c_get_plip_id is
1132: select plip.plip_id
1133: from ben_plip_f plip
1134: where plip.pl_id = l_pl_id
1135: and plip.pgm_id = l_pgm_id
1136: and plip.business_group_id = p_business_group_id;
1137: