APPS.GHR_GENERAL dependencies on BEN_PGM_F

Line 169: l_pgm_id ben_pgm_f.pgm_id%type;

165: l_person_count number;
166: l_plan_nip_count number;
167: l_oipl_nip_count number;
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;

Line 232: from ben_pgm_f pgm

228:
229: -- Cursor to get Pgm_id for the given Business Group
230: Cursor get_pgm_id is
231: select pgm.pgm_id
232: from ben_pgm_f pgm
233: where pgm.name = 'Federal Employees Health Benefits'
234: and pgm.business_group_id = p_business_group_id
235: and p_effective_date between effective_start_date and effective_end_date;
236:

Line 714: l_pgm_id ben_pgm_f.pgm_id%type;

710: l_person_count number;
711: l_plan_nip_count number;
712: l_oipl_nip_count number;
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;

Line 763: from ben_pgm_f pgm

759:
760: -- Cursor to get Pgm_id for the given Business Group
761: Cursor c_get_pgm_id is
762: select pgm.pgm_id
763: from ben_pgm_f pgm
764: where pgm.name = 'Federal Thrift Savings Plan (TSP)'
765: and pgm.business_group_id = p_business_group_id;
766:
767: --Cursor to get the Plan Type Id for the given Business_group_id

Line 1083: l_pgm_id ben_pgm_f.pgm_id%type;

1079: l_person_count number;
1080: l_plan_nip_count number;
1081: l_oipl_nip_count number;
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;

Line 1131: from ben_pgm_f pgm

1127:
1128: -- Cursor to get Pgm_id for the given Business Group
1129: Cursor c_get_pgm_id is
1130: select pgm.pgm_id
1131: from ben_pgm_f pgm
1132: where pgm.name = 'Federal Thrift Savings Plan (TSP) Catch Up Contributions'
1133: and pgm.business_group_id = p_business_group_id;
1134:
1135: --Cursor to get the Plan Type Id for the given Business_group_id