DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on BEN_PRTT_ENRT_RSLT_F

Line 324: from ben_prtt_enrt_rslt_f prt

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

Line 822: from ben_prtt_enrt_rslt_f

818:
819: -- Cursor to check if Employee is currently enrolled in TSP
820: cursor c_emp_in_tsp is
821: select 1
822: from ben_prtt_enrt_rslt_f
823: where person_id = p_person_id
824: and pgm_id = l_pgm_id;
825:
826: Cursor c_get_ssn is

Line 1177: from ben_prtt_enrt_rslt_f

1173:
1174: -- Cursor to check if Employee is currently enrolled in TSP Catchup
1175: cursor c_emp_in_tsp is
1176: select 1
1177: from ben_prtt_enrt_rslt_f
1178: where person_id = p_person_id
1179: and pgm_id = l_pgm_id;
1180:
1181: Cursor c_get_ssn is