[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;
262:
263: --Cursor to get the plan in Program Id for the given Pl_id
264: Cursor get_plip_id is
265: select plip.plip_id
266: from ben_plip_f plip
267: where plip.pl_id = l_pl_id
268: and plip.pgm_id = l_pgm_id
269: and plip.business_group_id = p_business_group_id
270: and p_effective_date between effective_start_date and effective_end_date;
714: l_pgm_id ben_pgm_f.pgm_id%type;
715: l_pl_id ben_pl_f.pl_id%type;
716: l_opt_id ben_opt_f.opt_id%type;
717: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
718: l_plip_id ben_plip_f.plip_id%type;
719: l_oipl_id ben_oipl_f.oipl_id%type;
720: l_ler_id ben_ler_f.ler_id%type;
721: l_ptip_id ben_ptip_f.ptip_id%type;
722: l_assignment_id per_all_assignments_f.assignment_id%type;
787:
788: --Cursor to get the plan in Program Id for the given Pl_id
789: Cursor c_get_plip_id is
790: select plip.plip_id
791: from ben_plip_f plip
792: where plip.pl_id = l_pl_id
793: and plip.pgm_id = l_pgm_id
794: and plip.business_group_id = p_business_group_id;
795:
1083: l_pgm_id ben_pgm_f.pgm_id%type;
1084: l_pl_id ben_pl_f.pl_id%type;
1085: l_opt_id ben_opt_f.opt_id%type;
1086: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1087: l_plip_id ben_plip_f.plip_id%type;
1088: l_oipl_id ben_oipl_f.oipl_id%type;
1089: l_ler_id ben_ler_f.ler_id%type;
1090: l_ptip_id ben_ptip_f.ptip_id%type;
1091: l_exists boolean;
1155:
1156: --Cursor to get the plan in Program Id for the given Pl_id
1157: Cursor c_get_plip_id is
1158: select plip.plip_id
1159: from ben_plip_f plip
1160: where plip.pl_id = l_pl_id
1161: and plip.pgm_id = l_pgm_id
1162: and plip.business_group_id = p_business_group_id;
1163: