APPS.GHR_UTILITY dependencies on BEN_PGM_F

Line 27: FROM ben_pgm_f

23: AND hoi.org_information6 = 'Y';
24:
25: CURSOR c_ben_pgm (p_current_bg NUMBER) IS
26: SELECT 1
27: FROM ben_pgm_f
28: WHERE name = 'Federal Employees Health Benefits' and business_group_id = p_current_bg;
29:
30: CURSOR c_ben_pgm_fehb (p_current_bg NUMBER) IS
31: SELECT 1

Line 30: CURSOR c_ben_pgm_fehb (p_current_bg NUMBER) IS

26: SELECT 1
27: FROM ben_pgm_f
28: WHERE name = 'Federal Employees Health Benefits' and business_group_id = p_current_bg;
29:
30: CURSOR c_ben_pgm_fehb (p_current_bg NUMBER) IS
31: SELECT 1
32: FROM ben_pgm_f
33: WHERE name = 'Federal Employees Health Benefits'
34: and business_group_id = p_current_bg

Line 32: FROM ben_pgm_f

28: WHERE name = 'Federal Employees Health Benefits' and business_group_id = p_current_bg;
29:
30: CURSOR c_ben_pgm_fehb (p_current_bg NUMBER) IS
31: SELECT 1
32: FROM ben_pgm_f
33: WHERE name = 'Federal Employees Health Benefits'
34: and business_group_id = p_current_bg
35: and pgm_stat_cd = 'A';
36:

Line 39: FROM ben_pgm_f

35: and pgm_stat_cd = 'A';
36:
37: CURSOR c_ben_pgm_tsp (p_current_bg NUMBER) IS
38: SELECT 1
39: FROM ben_pgm_f
40: WHERE name = 'Federal Thrift Savings Plan (TSP)'
41: and business_group_id = p_current_bg
42: and pgm_stat_cd = 'A';
43:

Line 47: r_ben_pgm_fehb c_ben_pgm%ROWTYPE;

43:
44: r_fed_bg c_fed_bg%ROWTYPE;
45: v_is_ghr VARCHAR2(10);
46: r_ben_pgm c_ben_pgm%ROWTYPE;
47: r_ben_pgm_fehb c_ben_pgm%ROWTYPE;
48: r_ben_pgm_tsp c_ben_pgm%ROWTYPE;
49: v_is_ghr_ben VARCHAR2(10);
50: v_is_ghr_ben_fehb VARCHAR2(10);
51: v_is_ghr_ben_tsp VARCHAR2(10);

Line 1002: OPEN c_ben_pgm_fehb(v_current_bg);

998: CLOSE c_ben_pgm;
999:
1000:
1001: v_is_ghr_ben_fehb := 'TRUE';
1002: OPEN c_ben_pgm_fehb(v_current_bg);
1003: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1004: IF c_ben_pgm_fehb%NOTFOUND THEN
1005: v_is_ghr_ben_fehb := 'FALSE';
1006: END IF;

Line 1003: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;

999:
1000:
1001: v_is_ghr_ben_fehb := 'TRUE';
1002: OPEN c_ben_pgm_fehb(v_current_bg);
1003: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1004: IF c_ben_pgm_fehb%NOTFOUND THEN
1005: v_is_ghr_ben_fehb := 'FALSE';
1006: END IF;
1007: CLOSE c_ben_pgm_fehb;

Line 1004: IF c_ben_pgm_fehb%NOTFOUND THEN

1000:
1001: v_is_ghr_ben_fehb := 'TRUE';
1002: OPEN c_ben_pgm_fehb(v_current_bg);
1003: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1004: IF c_ben_pgm_fehb%NOTFOUND THEN
1005: v_is_ghr_ben_fehb := 'FALSE';
1006: END IF;
1007: CLOSE c_ben_pgm_fehb;
1008:

Line 1007: CLOSE c_ben_pgm_fehb;

1003: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1004: IF c_ben_pgm_fehb%NOTFOUND THEN
1005: v_is_ghr_ben_fehb := 'FALSE';
1006: END IF;
1007: CLOSE c_ben_pgm_fehb;
1008:
1009:
1010: v_is_ghr_ben_tsp := 'TRUE';
1011: OPEN c_ben_pgm_tsp(v_current_bg);