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 276: from ben_opt_f opt

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

Line 716: l_opt_id ben_opt_f.opt_id%type;

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

Line 799: from ben_opt_f opt

795:
796: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
797: Cursor c_get_opt_id is
798: Select opt_id
799: from ben_opt_f opt
800: where name = p_opt_name
801: and opt.business_group_id = p_business_group_id;
802:
803: -- Cursor to get the option in plan Id

Line 1085: l_opt_id ben_opt_f.opt_id%type;

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

Line 1167: from ben_opt_f opt

1163:
1164: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
1165: Cursor c_get_opt_id is
1166: Select opt_id
1167: from ben_opt_f opt
1168: where name = p_opt_name
1169: and opt.business_group_id = p_business_group_id;
1170:
1171: -- Cursor to get the option in plan Id