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 238: from ben_pl_typ_f plt

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

Line 705: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

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

Line 756: from ben_pl_typ_f plt

752:
753: --Cursor to get the Plan Type Id for the given Business_group_id
754: Cursor c_get_pl_typ_id is
755: select plt.pl_typ_id
756: from ben_pl_typ_f plt
757: where plt.name = 'Savings Plan'
758: and plt.business_group_id = p_business_group_id;
759:
760: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.

Line 1062: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

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

Line 1112: from ben_pl_typ_f plt

1108:
1109: --Cursor to get the Plan Type Id for the given Business_group_id
1110: Cursor c_get_pl_typ_id is
1111: select plt.pl_typ_id
1112: from ben_pl_typ_f plt
1113: where plt.name = 'Savings Plan'
1114: and plt.business_group_id = p_business_group_id;
1115:
1116: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.