APPS.GHR_GENERAL dependencies on BEN_PL_TYP_F

Line 172: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

168:
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;

Line 240: from ben_pl_typ_f plt

236:
237: --Cursor to get the Plan Type Id for the given Business_group_id
238: Cursor get_pl_typ_id is
239: select plt.pl_typ_id
240: from ben_pl_typ_f plt
241: where plt.name = 'Health Benefits'
242: and plt.business_group_id = p_business_group_id
243: and p_effective_date between effective_start_date and effective_end_date;
244:

Line 717: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

713:
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;

Line 770: from ben_pl_typ_f plt

766:
767: --Cursor to get the Plan Type Id for the given Business_group_id
768: Cursor c_get_pl_typ_id is
769: select plt.pl_typ_id
770: from ben_pl_typ_f plt
771: where plt.name = 'Savings Plan'
772: and plt.business_group_id = p_business_group_id;
773:
774: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.

Line 1086: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

1082:
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;

Line 1138: from ben_pl_typ_f plt

1134:
1135: --Cursor to get the Plan Type Id for the given Business_group_id
1136: Cursor c_get_pl_typ_id is
1137: select plt.pl_typ_id
1138: from ben_pl_typ_f plt
1139: where plt.name = 'Savings Plan'
1140: and plt.business_group_id = p_business_group_id;
1141:
1142: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.