eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 44: CURSOR c_ben_pgm_fegli (p_current_bg NUMBER) IS

40: WHERE name = 'Federal Thrift Savings Plan (TSP)'
41: and business_group_id = p_current_bg
42: and pgm_stat_cd = 'A';
43:
44: CURSOR c_ben_pgm_fegli (p_current_bg NUMBER) IS
45: SELECT 1
46: FROM ben_pgm_f
47: WHERE name = 'Federal Employees Life Insurance Program (FEGLI)'
48: and business_group_id = p_current_bg

Line 46: FROM ben_pgm_f

42: and pgm_stat_cd = 'A';
43:
44: CURSOR c_ben_pgm_fegli (p_current_bg NUMBER) IS
45: SELECT 1
46: FROM ben_pgm_f
47: WHERE name = 'Federal Employees Life Insurance Program (FEGLI)'
48: and business_group_id = p_current_bg
49: and pgm_stat_cd = 'A';
50:

Line 54: r_ben_pgm_fehb c_ben_pgm%ROWTYPE;

50:
51: r_fed_bg c_fed_bg%ROWTYPE;
52: v_is_ghr VARCHAR2(10);
53: r_ben_pgm c_ben_pgm%ROWTYPE;
54: r_ben_pgm_fehb c_ben_pgm%ROWTYPE;
55: r_ben_pgm_fegli c_ben_pgm%ROWTYPE;
56: r_ben_pgm_tsp c_ben_pgm%ROWTYPE;
57: v_is_ghr_ben VARCHAR2(10);
58: v_is_ghr_ben_fehb VARCHAR2(10);

Line 55: r_ben_pgm_fegli c_ben_pgm%ROWTYPE;

51: r_fed_bg c_fed_bg%ROWTYPE;
52: v_is_ghr VARCHAR2(10);
53: r_ben_pgm c_ben_pgm%ROWTYPE;
54: r_ben_pgm_fehb c_ben_pgm%ROWTYPE;
55: r_ben_pgm_fegli c_ben_pgm%ROWTYPE;
56: r_ben_pgm_tsp c_ben_pgm%ROWTYPE;
57: v_is_ghr_ben VARCHAR2(10);
58: v_is_ghr_ben_fehb VARCHAR2(10);
59: v_is_ghr_ben_tsp VARCHAR2(10);

Line 1019: OPEN c_ben_pgm_fehb(v_current_bg);

1015: CLOSE c_ben_pgm;
1016:
1017:
1018: v_is_ghr_ben_fehb := 'TRUE';
1019: OPEN c_ben_pgm_fehb(v_current_bg);
1020: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1021: IF c_ben_pgm_fehb%NOTFOUND THEN
1022: v_is_ghr_ben_fehb := 'FALSE';
1023: END IF;

Line 1020: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;

1016:
1017:
1018: v_is_ghr_ben_fehb := 'TRUE';
1019: OPEN c_ben_pgm_fehb(v_current_bg);
1020: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1021: IF c_ben_pgm_fehb%NOTFOUND THEN
1022: v_is_ghr_ben_fehb := 'FALSE';
1023: END IF;
1024: CLOSE c_ben_pgm_fehb;

Line 1021: IF c_ben_pgm_fehb%NOTFOUND THEN

1017:
1018: v_is_ghr_ben_fehb := 'TRUE';
1019: OPEN c_ben_pgm_fehb(v_current_bg);
1020: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1021: IF c_ben_pgm_fehb%NOTFOUND THEN
1022: v_is_ghr_ben_fehb := 'FALSE';
1023: END IF;
1024: CLOSE c_ben_pgm_fehb;
1025:

Line 1024: CLOSE c_ben_pgm_fehb;

1020: FETCH c_ben_pgm_fehb INTO r_ben_pgm_fehb;
1021: IF c_ben_pgm_fehb%NOTFOUND THEN
1022: v_is_ghr_ben_fehb := 'FALSE';
1023: END IF;
1024: CLOSE c_ben_pgm_fehb;
1025:
1026:
1027: v_is_ghr_ben_tsp := 'TRUE';
1028: OPEN c_ben_pgm_tsp(v_current_bg);

Line 1046: OPEN c_ben_pgm_fegli(v_current_bg);

1042: CLOSE c_fed_nfc;
1043:
1044: --FEGLI
1045: v_is_ghr_ben_fegli := 'TRUE';
1046: OPEN c_ben_pgm_fegli(v_current_bg);
1047: FETCH c_ben_pgm_fegli INTO r_ben_pgm_fegli;
1048: IF c_ben_pgm_fegli%NOTFOUND THEN
1049: v_is_ghr_ben_fegli := 'FALSE';
1050: END IF;

Line 1047: FETCH c_ben_pgm_fegli INTO r_ben_pgm_fegli;

1043:
1044: --FEGLI
1045: v_is_ghr_ben_fegli := 'TRUE';
1046: OPEN c_ben_pgm_fegli(v_current_bg);
1047: FETCH c_ben_pgm_fegli INTO r_ben_pgm_fegli;
1048: IF c_ben_pgm_fegli%NOTFOUND THEN
1049: v_is_ghr_ben_fegli := 'FALSE';
1050: END IF;
1051: CLOSE c_ben_pgm_fegli;

Line 1048: IF c_ben_pgm_fegli%NOTFOUND THEN

1044: --FEGLI
1045: v_is_ghr_ben_fegli := 'TRUE';
1046: OPEN c_ben_pgm_fegli(v_current_bg);
1047: FETCH c_ben_pgm_fegli INTO r_ben_pgm_fegli;
1048: IF c_ben_pgm_fegli%NOTFOUND THEN
1049: v_is_ghr_ben_fegli := 'FALSE';
1050: END IF;
1051: CLOSE c_ben_pgm_fegli;
1052: --FEGLI

Line 1051: CLOSE c_ben_pgm_fegli;

1047: FETCH c_ben_pgm_fegli INTO r_ben_pgm_fegli;
1048: IF c_ben_pgm_fegli%NOTFOUND THEN
1049: v_is_ghr_ben_fegli := 'FALSE';
1050: END IF;
1051: CLOSE c_ben_pgm_fegli;
1052: --FEGLI
1053:
1054:
1055: -- DK 2002-11-08 PLSQLSTD