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 257: from ben_pl_f pln

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

Line 715: l_pl_id ben_pl_f.pl_id%type;

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

Line 784: from ben_pl_f pln

780:
781: -- Cursor to get the Plan Id
782: Cursor c_get_pl_id is
783: select pln.pl_id pl_id
784: from ben_pl_f pln
785: where pln.name = 'TSP'
786: and pln.business_group_id = p_business_group_id;
787:
788: --Cursor to get the plan in Program Id for the given Pl_id

Line 1084: l_pl_id ben_pl_f.pl_id%type;

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

Line 1152: from ben_pl_f pln

1148:
1149: -- Cursor to get the Plan Id
1150: Cursor c_get_pl_id is
1151: select pln.pl_id pl_id
1152: from ben_pl_f pln
1153: where pln.name = 'TSP Catch Up'
1154: and pln.business_group_id = p_business_group_id;
1155:
1156: --Cursor to get the plan in Program Id for the given Pl_id