APPS.GHR_GENERAL dependencies on BEN_PL_F

Line 155: p_health_plan in ben_pl_f.short_code%type,

151: p_assignment_id in per_assignments_f.assignment_id%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

Line 170: l_pl_id ben_pl_f.pl_id%type;

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

Line 255: from ben_pl_f pln

251:
252: -- Cursor to get the Plan Id for the EE's Health Plan screen entry value
253: Cursor get_pl_id is
254: select pln.pl_id pl_id
255: from ben_pl_f pln
256: where pln.short_code = p_health_plan
257: and pln.business_group_id = p_business_group_id
258: and p_effective_date between effective_start_date and effective_end_date
259: and pl_stat_cd = 'A';

Line 703: l_pl_id ben_pl_f.pl_id%type;

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

Line 770: from ben_pl_f pln

766:
767: -- Cursor to get the Plan Id
768: Cursor c_get_pl_id is
769: select pln.pl_id pl_id
770: from ben_pl_f pln
771: where pln.name = 'TSP'
772: and pln.business_group_id = p_business_group_id;
773:
774: --Cursor to get the plan in Program Id for the given Pl_id

Line 1060: l_pl_id ben_pl_f.pl_id%type;

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

Line 1126: from ben_pl_f pln

1122:
1123: -- Cursor to get the Plan Id
1124: Cursor c_get_pl_id is
1125: select pln.pl_id pl_id
1126: from ben_pl_f pln
1127: where pln.name = 'TSP Catch Up'
1128: and pln.business_group_id = p_business_group_id;
1129:
1130: --Cursor to get the plan in Program Id for the given Pl_id