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 230: from ben_pgm_f pgm

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

Line 702: l_pgm_id ben_pgm_f.pgm_id%type;

698: l_person_count number;
699: l_plan_nip_count number;
700: l_oipl_nip_count number;
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;

Line 749: from ben_pgm_f pgm

745:
746: -- Cursor to get Pgm_id for the given Business Group
747: Cursor c_get_pgm_id is
748: select pgm.pgm_id
749: from ben_pgm_f pgm
750: where pgm.name = 'Federal Thrift Savings Plan (TSP)'
751: and pgm.business_group_id = p_business_group_id;
752:
753: --Cursor to get the Plan Type Id for the given Business_group_id

Line 1059: l_pgm_id ben_pgm_f.pgm_id%type;

1055: l_person_count number;
1056: l_plan_nip_count number;
1057: l_oipl_nip_count number;
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;

Line 1105: from ben_pgm_f pgm

1101:
1102: -- Cursor to get Pgm_id for the given Business Group
1103: Cursor c_get_pgm_id is
1104: select pgm.pgm_id
1105: from ben_pgm_f pgm
1106: where pgm.name = 'Federal Thrift Savings Plan (TSP) Catch Up Contributions'
1107: and pgm.business_group_id = p_business_group_id;
1108:
1109: --Cursor to get the Plan Type Id for the given Business_group_id