APPS.GHR_GENERAL dependencies on BEN_OPT_F

Line 156: p_option_code in ben_opt_f.short_code%type,

152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,
158: p_object_version_number in pay_element_entries_f.object_version_number%type,
159: p_temps_cost in pay_element_entry_values_f.screen_entry_value%type) is
160:

Line 171: l_opt_id ben_opt_f.opt_id%type;

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;
174: l_oipl_id ben_oipl_f.oipl_id%type;
175: l_ler_id ben_ler_f.ler_id%type;

Line 274: from ben_opt_f opt

270:
271: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
272: Cursor get_opt_id is
273: Select opt_id
274: from ben_opt_f opt
275: where opt.short_code = p_option_code
276: and opt.business_group_id = p_business_group_id
277: and p_effective_date between effective_start_date and effective_end_date;
278:

Line 704: l_opt_id ben_opt_f.opt_id%type;

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;
707: l_oipl_id ben_oipl_f.oipl_id%type;
708: l_ler_id ben_ler_f.ler_id%type;

Line 785: from ben_opt_f opt

781:
782: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
783: Cursor c_get_opt_id is
784: Select opt_id
785: from ben_opt_f opt
786: where name = p_opt_name
787: and opt.business_group_id = p_business_group_id;
788:
789: -- Cursor to get the option in plan Id

Line 1061: l_opt_id ben_opt_f.opt_id%type;

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;
1064: l_oipl_id ben_oipl_f.oipl_id%type;
1065: l_ler_id ben_ler_f.ler_id%type;

Line 1141: from ben_opt_f opt

1137:
1138: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
1139: Cursor c_get_opt_id is
1140: Select opt_id
1141: from ben_opt_f opt
1142: where name = p_opt_name
1143: and opt.business_group_id = p_business_group_id;
1144:
1145: -- Cursor to get the option in plan Id