DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on BEN_PRTT_ENRT_RSLT_F

Line 326: from ben_prtt_enrt_rslt_f prt

322: -- Cursor to check if Employee is currently enrolled in FEHB including
323: -- enrollments made in his prior employment
324: cursor c_emp_in_fehb is
325: select 1
326: from ben_prtt_enrt_rslt_f prt
327: where prt.person_id = p_person_id
328: and pgm_id = l_pgm_id;
329:
330: cursor c_get_ovn is

Line 836: from ben_prtt_enrt_rslt_f

832:
833: -- Cursor to check if Employee is currently enrolled in TSP
834: cursor c_emp_in_tsp is
835: select 1
836: from ben_prtt_enrt_rslt_f
837: where person_id = p_person_id
838: and pgm_id = l_pgm_id;
839:
840: Cursor c_get_ssn is

Line 1203: from ben_prtt_enrt_rslt_f

1199:
1200: -- Cursor to check if Employee is currently enrolled in TSP Catchup
1201: cursor c_emp_in_tsp is
1202: select 1
1203: from ben_prtt_enrt_rslt_f
1204: where person_id = p_person_id
1205: and pgm_id = l_pgm_id;
1206:
1207: Cursor c_get_ssn is