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.BEN_ELP_CACHE dependencies on BEN_CACHE

Line 12: g_cobcep_lookup ben_cache.g_cache_lookup_table;

8: g_hash_jump number := ben_hash_utility.get_hash_jump;
9: --
10: -- cobcep
11: --
12: g_cobcep_lookup ben_cache.g_cache_lookup_table;
13: g_cobcep_inst ben_elp_cache.g_cobcep_cache;
14: g_cobcep_cached boolean := FALSE;
15: --
16: -- eligibility profile person type by eligibility profile

Line 18: g_cache_elpept_lookup ben_cache.g_cache_lookup_table;

14: g_cobcep_cached boolean := FALSE;
15: --
16: -- eligibility profile person type by eligibility profile
17: --
18: g_cache_elpept_lookup ben_cache.g_cache_lookup_table;
19: g_cache_elpept_inst ben_elp_cache.g_cache_elpept_instor;
20: --
21: -- eligibility profile people group by eligibility profile
22: --

Line 23: g_cache_elpepg_lookup ben_cache.g_cache_lookup_table;

19: g_cache_elpept_inst ben_elp_cache.g_cache_elpept_instor;
20: --
21: -- eligibility profile people group by eligibility profile
22: --
23: g_cache_elpepg_lookup ben_cache.g_cache_lookup_table;
24: g_cache_elpepg_inst ben_elp_cache.g_cache_elpepg_instor;
25: --
26: -- eligibility profile rule by eligibility profile
27: --

Line 28: g_cache_elperl_lookup ben_cache.g_cache_lookup_table;

24: g_cache_elpepg_inst ben_elp_cache.g_cache_elpepg_instor;
25: --
26: -- eligibility profile rule by eligibility profile
27: --
28: g_cache_elperl_lookup ben_cache.g_cache_lookup_table;
29: g_cache_elperl_inst ben_elp_cache.g_cache_elperl_instor;
30: --
31: -- eligibility profile assignment status type by eligibility profile
32: --

Line 33: g_cache_elpees_lookup ben_cache.g_cache_lookup_table;

29: g_cache_elperl_inst ben_elp_cache.g_cache_elperl_instor;
30: --
31: -- eligibility profile assignment status type by eligibility profile
32: --
33: g_cache_elpees_lookup ben_cache.g_cache_lookup_table;
34: g_cache_elpees_inst ben_elp_cache.g_cache_elpees_instor;
35: --
36: -- eligibility profile length of service by eligibility profile
37: --

Line 38: g_cache_elpels_lookup ben_cache.g_cache_lookup_table;

34: g_cache_elpees_inst ben_elp_cache.g_cache_elpees_instor;
35: --
36: -- eligibility profile length of service by eligibility profile
37: --
38: g_cache_elpels_lookup ben_cache.g_cache_lookup_table;
39: g_cache_elpels_inst ben_elp_cache.g_cache_elpels_instor;
40: --
41: -- eligibility profile age/los combination by eligibility profile
42: --

Line 43: g_cache_elpecp_lookup ben_cache.g_cache_lookup_table;

39: g_cache_elpels_inst ben_elp_cache.g_cache_elpels_instor;
40: --
41: -- eligibility profile age/los combination by eligibility profile
42: --
43: g_cache_elpecp_lookup ben_cache.g_cache_lookup_table;
44: g_cache_elpecp_inst ben_elp_cache.g_cache_elpecp_instor;
45: --
46: -- eligibility profile location by eligibility profile
47: --

Line 48: g_cache_elpewl_lookup ben_cache.g_cache_lookup_table;

44: g_cache_elpecp_inst ben_elp_cache.g_cache_elpecp_instor;
45: --
46: -- eligibility profile location by eligibility profile
47: --
48: g_cache_elpewl_lookup ben_cache.g_cache_lookup_table;
49: g_cache_elpewl_inst ben_elp_cache.g_cache_elpewl_instor;
50: --
51: -- eligibility profile assignment set by eligibility profile
52: --

Line 53: g_cache_elpean_lookup ben_cache.g_cache_lookup_table;

49: g_cache_elpewl_inst ben_elp_cache.g_cache_elpewl_instor;
50: --
51: -- eligibility profile assignment set by eligibility profile
52: --
53: g_cache_elpean_lookup ben_cache.g_cache_lookup_table;
54: g_cache_elpean_inst ben_elp_cache.g_cache_elpean_instor;
55: --
56: -- eligibility profile organization by eligibility profile
57: --

Line 58: g_cache_elpeou_lookup ben_cache.g_cache_lookup_table;

54: g_cache_elpean_inst ben_elp_cache.g_cache_elpean_instor;
55: --
56: -- eligibility profile organization by eligibility profile
57: --
58: g_cache_elpeou_lookup ben_cache.g_cache_lookup_table;
59: g_cache_elpeou_inst ben_elp_cache.g_cache_elpeou_instor;
60: --
61: -- eligibility profile pay frequency by eligibility profile
62: --

Line 63: g_cache_elpehs_lookup ben_cache.g_cache_lookup_table;

59: g_cache_elpeou_inst ben_elp_cache.g_cache_elpeou_instor;
60: --
61: -- eligibility profile pay frequency by eligibility profile
62: --
63: g_cache_elpehs_lookup ben_cache.g_cache_lookup_table;
64: g_cache_elpehs_inst ben_elp_cache.g_cache_elpehs_instor;
65: --
66: -- eligibility profile full/part time by eligibility profile
67: --

Line 68: g_cache_elpefp_lookup ben_cache.g_cache_lookup_table;

64: g_cache_elpehs_inst ben_elp_cache.g_cache_elpehs_instor;
65: --
66: -- eligibility profile full/part time by eligibility profile
67: --
68: g_cache_elpefp_lookup ben_cache.g_cache_lookup_table;
69: g_cache_elpefp_inst ben_elp_cache.g_cache_elpefp_instor;
70: --
71: -- eligibility profile scheduled hours by eligibility profile
72: --

Line 73: g_cache_elpesh_lookup ben_cache.g_cache_lookup_table;

69: g_cache_elpefp_inst ben_elp_cache.g_cache_elpefp_instor;
70: --
71: -- eligibility profile scheduled hours by eligibility profile
72: --
73: g_cache_elpesh_lookup ben_cache.g_cache_lookup_table;
74: g_cache_elpesh_inst ben_elp_cache.g_cache_elpesh_instor;
75: --
76: -- eligibility profile compensation level by eligibility profile
77: --

Line 78: g_cache_elpecl_lookup ben_cache.g_cache_lookup_table;

74: g_cache_elpesh_inst ben_elp_cache.g_cache_elpesh_instor;
75: --
76: -- eligibility profile compensation level by eligibility profile
77: --
78: g_cache_elpecl_lookup ben_cache.g_cache_lookup_table;
79: g_cache_elpecl_inst ben_elp_cache.g_cache_elpecl_instor;
80: --
81: -- eligibility profile hours worked by eligibility profile
82: --

Line 83: g_cache_elpehw_lookup ben_cache.g_cache_lookup_table;

79: g_cache_elpecl_inst ben_elp_cache.g_cache_elpecl_instor;
80: --
81: -- eligibility profile hours worked by eligibility profile
82: --
83: g_cache_elpehw_lookup ben_cache.g_cache_lookup_table;
84: g_cache_elpehw_inst ben_elp_cache.g_cache_elpehw_instor;
85: --
86: -- eligibility profile full time by eligibility profile
87: --

Line 88: g_cache_elpepf_lookup ben_cache.g_cache_lookup_table;

84: g_cache_elpehw_inst ben_elp_cache.g_cache_elpehw_instor;
85: --
86: -- eligibility profile full time by eligibility profile
87: --
88: g_cache_elpepf_lookup ben_cache.g_cache_lookup_table;
89: g_cache_elpepf_inst ben_elp_cache.g_cache_elpepf_instor;
90: --
91: -- eligibility profile grade by eligibility profile
92: --

Line 93: g_cache_elpegr_lookup ben_cache.g_cache_lookup_table;

89: g_cache_elpepf_inst ben_elp_cache.g_cache_elpepf_instor;
90: --
91: -- eligibility profile grade by eligibility profile
92: --
93: g_cache_elpegr_lookup ben_cache.g_cache_lookup_table;
94: g_cache_elpegr_inst ben_elp_cache.g_cache_elpegr_instor;
95: --
96: -- eligibility profile sex by eligibility profile
97: --

Line 98: g_cache_elpegn_lookup ben_cache.g_cache_lookup_table;

94: g_cache_elpegr_inst ben_elp_cache.g_cache_elpegr_instor;
95: --
96: -- eligibility profile sex by eligibility profile
97: --
98: g_cache_elpegn_lookup ben_cache.g_cache_lookup_table;
99: g_cache_elpegn_inst ben_elp_cache.g_cache_elpegn_instor;
100: --
101: -- eligibility profile job by eligibility profile
102: --

Line 103: g_cache_elpejp_lookup ben_cache.g_cache_lookup_table;

99: g_cache_elpegn_inst ben_elp_cache.g_cache_elpegn_instor;
100: --
101: -- eligibility profile job by eligibility profile
102: --
103: g_cache_elpejp_lookup ben_cache.g_cache_lookup_table;
104: g_cache_elpejp_inst ben_elp_cache.g_cache_elpejp_instor;
105: --
106: -- eligibility profile pay basis by eligibility profile
107: --

Line 108: g_cache_elpepb_lookup ben_cache.g_cache_lookup_table;

104: g_cache_elpejp_inst ben_elp_cache.g_cache_elpejp_instor;
105: --
106: -- eligibility profile pay basis by eligibility profile
107: --
108: g_cache_elpepb_lookup ben_cache.g_cache_lookup_table;
109: g_cache_elpepb_inst ben_elp_cache.g_cache_elpepb_instor;
110: --
111: -- eligibility profile service area by eligibility profile
112: --

Line 113: g_cache_elpesa_lookup ben_cache.g_cache_lookup_table;

109: g_cache_elpepb_inst ben_elp_cache.g_cache_elpepb_instor;
110: --
111: -- eligibility profile service area by eligibility profile
112: --
113: g_cache_elpesa_lookup ben_cache.g_cache_lookup_table;
114: g_cache_elpesa_inst ben_elp_cache.g_cache_elpesa_instor;
115: --
116: -- eligibility profile payroll by eligibility profile
117: --

Line 118: g_cache_elpepy_lookup ben_cache.g_cache_lookup_table;

114: g_cache_elpesa_inst ben_elp_cache.g_cache_elpesa_instor;
115: --
116: -- eligibility profile payroll by eligibility profile
117: --
118: g_cache_elpepy_lookup ben_cache.g_cache_lookup_table;
119: g_cache_elpepy_inst ben_elp_cache.g_cache_elpepy_instor;
120: --
121: -- eligibility profile bargaining unit by eligibility profile
122: --

Line 123: g_cache_elpebu_lookup ben_cache.g_cache_lookup_table;

119: g_cache_elpepy_inst ben_elp_cache.g_cache_elpepy_instor;
120: --
121: -- eligibility profile bargaining unit by eligibility profile
122: --
123: g_cache_elpebu_lookup ben_cache.g_cache_lookup_table;
124: g_cache_elpebu_inst ben_elp_cache.g_cache_elpebu_instor;
125: --
126: -- eligibility profile labour union membership by eligibility profile
127: --

Line 128: g_cache_elpelu_lookup ben_cache.g_cache_lookup_table;

124: g_cache_elpebu_inst ben_elp_cache.g_cache_elpebu_instor;
125: --
126: -- eligibility profile labour union membership by eligibility profile
127: --
128: g_cache_elpelu_lookup ben_cache.g_cache_lookup_table;
129: g_cache_elpelu_inst ben_elp_cache.g_cache_elpelu_instor;
130: --
131: -- eligibility profile leave of absence reason by eligibility profile
132: --

Line 133: g_cache_elpelr_lookup ben_cache.g_cache_lookup_table;

129: g_cache_elpelu_inst ben_elp_cache.g_cache_elpelu_instor;
130: --
131: -- eligibility profile leave of absence reason by eligibility profile
132: --
133: g_cache_elpelr_lookup ben_cache.g_cache_lookup_table;
134: g_cache_elpelr_inst ben_elp_cache.g_cache_elpelr_instor;
135: --
136: -- eligibility profile age details by eligibility profile
137: --

Line 138: g_cache_elpeap_lookup ben_cache.g_cache_lookup_table;

134: g_cache_elpelr_inst ben_elp_cache.g_cache_elpelr_instor;
135: --
136: -- eligibility profile age details by eligibility profile
137: --
138: g_cache_elpeap_lookup ben_cache.g_cache_lookup_table;
139: g_cache_elpeap_inst ben_elp_cache.g_cache_elpeap_instor;
140: --
141: -- eligibility profile zip code range by eligibility profile
142: --

Line 143: g_cache_elpepz_lookup ben_cache.g_cache_lookup_table;

139: g_cache_elpeap_inst ben_elp_cache.g_cache_elpeap_instor;
140: --
141: -- eligibility profile zip code range by eligibility profile
142: --
143: g_cache_elpepz_lookup ben_cache.g_cache_lookup_table;
144: g_cache_elpepz_inst ben_elp_cache.g_cache_elpepz_instor;
145: --
146: -- eligibility profile benefits group by eligibility profile
147: --

Line 148: g_cache_elpebn_lookup ben_cache.g_cache_lookup_table;

144: g_cache_elpepz_inst ben_elp_cache.g_cache_elpepz_instor;
145: --
146: -- eligibility profile benefits group by eligibility profile
147: --
148: g_cache_elpebn_lookup ben_cache.g_cache_lookup_table;
149: g_cache_elpebn_inst ben_elp_cache.g_cache_elpebn_instor;
150: --
151: -- eligibility profile legal entity by eligibility profile
152: --

Line 153: g_cache_elpeln_lookup ben_cache.g_cache_lookup_table;

149: g_cache_elpebn_inst ben_elp_cache.g_cache_elpebn_instor;
150: --
151: -- eligibility profile legal entity by eligibility profile
152: --
153: g_cache_elpeln_lookup ben_cache.g_cache_lookup_table;
154: g_cache_elpeln_inst ben_elp_cache.g_cache_elpeln_instor;
155: --
156: -- eligibility profile other plan by eligibility profile
157: --

Line 158: g_cache_elpepp_lookup ben_cache.g_cache_lookup_table;

154: g_cache_elpeln_inst ben_elp_cache.g_cache_elpeln_instor;
155: --
156: -- eligibility profile other plan by eligibility profile
157: --
158: g_cache_elpepp_lookup ben_cache.g_cache_lookup_table;
159: g_cache_elpepp_inst ben_elp_cache.g_cache_elpepp_instor;
160: --
161: -- eligibility profile elig other ptip by eligibility profile
162: --

Line 163: g_cache_elpeoy_lookup ben_cache.g_cache_lookup_table;

159: g_cache_elpepp_inst ben_elp_cache.g_cache_elpepp_instor;
160: --
161: -- eligibility profile elig other ptip by eligibility profile
162: --
163: g_cache_elpeoy_lookup ben_cache.g_cache_lookup_table;
164: g_cache_elpeoy_inst ben_elp_cache.g_cache_elpeoy_instor;
165: --
166: -- eligibility profile no other coverage participate by eligibility profile
167: --

Line 168: g_cache_elpetd_lookup ben_cache.g_cache_lookup_table;

164: g_cache_elpeoy_inst ben_elp_cache.g_cache_elpeoy_instor;
165: --
166: -- eligibility profile no other coverage participate by eligibility profile
167: --
168: g_cache_elpetd_lookup ben_cache.g_cache_lookup_table;
169: g_cache_elpetd_inst ben_elp_cache.g_cache_elpetd_instor;
170: --
171: -- eligibility profile no other dpnt coverage participate by elig profile
172: --

Line 173: g_cache_elpeno_lookup ben_cache.g_cache_lookup_table;

169: g_cache_elpetd_inst ben_elp_cache.g_cache_elpetd_instor;
170: --
171: -- eligibility profile no other dpnt coverage participate by elig profile
172: --
173: g_cache_elpeno_lookup ben_cache.g_cache_lookup_table;
174: g_cache_elpeno_inst ben_elp_cache.g_cache_elpeno_instor;
175: --
176: -- eligibility profile enrolled another plan by eligibility profile
177: --

Line 178: g_cache_elpeep_lookup ben_cache.g_cache_lookup_table;

174: g_cache_elpeno_inst ben_elp_cache.g_cache_elpeno_instor;
175: --
176: -- eligibility profile enrolled another plan by eligibility profile
177: --
178: g_cache_elpeep_lookup ben_cache.g_cache_lookup_table;
179: g_cache_elpeep_inst ben_elp_cache.g_cache_elpeep_instor;
180: --
181: -- eligibility profile enrolled in another oipl by eligibility profile
182: --

Line 183: g_cache_elpeei_lookup ben_cache.g_cache_lookup_table;

179: g_cache_elpeep_inst ben_elp_cache.g_cache_elpeep_instor;
180: --
181: -- eligibility profile enrolled in another oipl by eligibility profile
182: --
183: g_cache_elpeei_lookup ben_cache.g_cache_lookup_table;
184: g_cache_elpeei_inst ben_elp_cache.g_cache_elpeei_instor;
185: --
186: -- eligibility profile enrolled in another pgm by eligibility profile
187: --

Line 188: g_cache_elpeeg_lookup ben_cache.g_cache_lookup_table;

184: g_cache_elpeei_inst ben_elp_cache.g_cache_elpeei_instor;
185: --
186: -- eligibility profile enrolled in another pgm by eligibility profile
187: --
188: g_cache_elpeeg_lookup ben_cache.g_cache_lookup_table;
189: g_cache_elpeeg_inst ben_elp_cache.g_cache_elpeeg_instor;
190: --
191: -- eligibility profile dependent covered other plan by eligibility profile
192: --

Line 193: g_cache_elpedp_lookup ben_cache.g_cache_lookup_table;

189: g_cache_elpeeg_inst ben_elp_cache.g_cache_elpeeg_instor;
190: --
191: -- eligibility profile dependent covered other plan by eligibility profile
192: --
193: g_cache_elpedp_lookup ben_cache.g_cache_lookup_table;
194: g_cache_elpedp_inst ben_elp_cache.g_cache_elpedp_instor;
195: --
196: -- eligibility profile leaving reason participate by eligibility profile
197: --

Line 198: g_cache_elpelv_lookup ben_cache.g_cache_lookup_table;

194: g_cache_elpedp_inst ben_elp_cache.g_cache_elpedp_instor;
195: --
196: -- eligibility profile leaving reason participate by eligibility profile
197: --
198: g_cache_elpelv_lookup ben_cache.g_cache_lookup_table;
199: g_cache_elpelv_inst ben_elp_cache.g_cache_elpelv_instor;
200: --
201: -- eligibility profile opted for medicare participate by eligibility profile
202: --

Line 203: g_cache_elpeom_lookup ben_cache.g_cache_lookup_table;

199: g_cache_elpelv_inst ben_elp_cache.g_cache_elpelv_instor;
200: --
201: -- eligibility profile opted for medicare participate by eligibility profile
202: --
203: g_cache_elpeom_lookup ben_cache.g_cache_lookup_table;
204: g_cache_elpeom_inst ben_elp_cache.g_cache_elpeom_instor;
205: --
206: -- eligibility profile enrolled in another plip by eligibility profile
207: --

Line 208: g_cache_elpeai_lookup ben_cache.g_cache_lookup_table;

204: g_cache_elpeom_inst ben_elp_cache.g_cache_elpeom_instor;
205: --
206: -- eligibility profile enrolled in another plip by eligibility profile
207: --
208: g_cache_elpeai_lookup ben_cache.g_cache_lookup_table;
209: g_cache_elpeai_inst ben_elp_cache.g_cache_elpeai_instor;
210: --
211: -- eligibility profile dependent covered othr plip by eligibility profile
212: --

Line 213: g_cache_elpedi_lookup ben_cache.g_cache_lookup_table;

209: g_cache_elpeai_inst ben_elp_cache.g_cache_elpeai_instor;
210: --
211: -- eligibility profile dependent covered othr plip by eligibility profile
212: --
213: g_cache_elpedi_lookup ben_cache.g_cache_lookup_table;
214: g_cache_elpedi_inst ben_elp_cache.g_cache_elpedi_instor;
215: --
216: -- eligibility profile enrolled another ptip by eligibility profile
217: --

Line 218: g_cache_elpeet_lookup ben_cache.g_cache_lookup_table;

214: g_cache_elpedi_inst ben_elp_cache.g_cache_elpedi_instor;
215: --
216: -- eligibility profile enrolled another ptip by eligibility profile
217: --
218: g_cache_elpeet_lookup ben_cache.g_cache_lookup_table;
219: g_cache_elpeet_inst ben_elp_cache.g_cache_elpeet_instor;
220: --
221: -- eligibility profile dependent covered in other ptip by eligibility profile
222: --

Line 223: g_cache_elpedt_lookup ben_cache.g_cache_lookup_table;

219: g_cache_elpeet_inst ben_elp_cache.g_cache_elpeet_instor;
220: --
221: -- eligibility profile dependent covered in other ptip by eligibility profile
222: --
223: g_cache_elpedt_lookup ben_cache.g_cache_lookup_table;
224: g_cache_elpedt_inst ben_elp_cache.g_cache_elpedt_instor;
225: --
226: -- eligibility profile dependent covered in other program by eligibility profile
227: --

Line 228: g_cache_elpedg_lookup ben_cache.g_cache_lookup_table;

224: g_cache_elpedt_inst ben_elp_cache.g_cache_elpedt_instor;
225: --
226: -- eligibility profile dependent covered in other program by eligibility profile
227: --
228: g_cache_elpedg_lookup ben_cache.g_cache_lookup_table;
229: g_cache_elpedg_inst ben_elp_cache.g_cache_elpedg_instor;
230: --
231: -- eligibility profile cobra qualified beneficiary by eligibility profile
232: --

Line 233: g_cache_elpecq_lookup ben_cache.g_cache_lookup_table;

229: g_cache_elpedg_inst ben_elp_cache.g_cache_elpedg_instor;
230: --
231: -- eligibility profile cobra qualified beneficiary by eligibility profile
232: --
233: g_cache_elpecq_lookup ben_cache.g_cache_lookup_table;
234: g_cache_elpecq_inst ben_elp_cache.g_cache_elpecq_instor;
235: --
236: g_copcep_odlookup ben_cache.g_cache_lookup_table;
237: g_copcep_nxelenum number;

Line 236: g_copcep_odlookup ben_cache.g_cache_lookup_table;

232: --
233: g_cache_elpecq_lookup ben_cache.g_cache_lookup_table;
234: g_cache_elpecq_inst ben_elp_cache.g_cache_elpecq_instor;
235: --
236: g_copcep_odlookup ben_cache.g_cache_lookup_table;
237: g_copcep_nxelenum number;
238: g_copcep_odinst ben_elp_cache.g_cobcep_odcache := ben_elp_cache.g_cobcep_odcache();
239: g_copcep_odcached pls_integer := 0;
240: --

Line 1494: l_instcolnm_set ben_cache.InstColNmType;

1490: is
1491: --
1492: l_proc varchar2(72) := 'elpelc_getdets';
1493: --
1494: l_instcolnm_set ben_cache.InstColNmType;
1495: l_tabdet_set ben_cache.TabDetType;
1496: --
1497: l_torrwnum pls_integer;
1498: l_insttorrw_num pls_integer;

Line 1495: l_tabdet_set ben_cache.TabDetType;

1491: --
1492: l_proc varchar2(72) := 'elpelc_getdets';
1493: --
1494: l_instcolnm_set ben_cache.InstColNmType;
1495: l_tabdet_set ben_cache.TabDetType;
1496: --
1497: l_torrwnum pls_integer;
1498: l_insttorrw_num pls_integer;
1499: l_index pls_integer;

Line 1680: ben_cache.Write_BGP_Cache

1676: l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
1677: l_instcolnm_num := l_instcolnm_num+1;
1678: --
1679: end if;
1680: ben_cache.Write_BGP_Cache
1681: (p_mastertab_name => l_mastertab_name
1682: ,p_masterpkcol_name => l_masterpkcol_name
1683: ,p_tabdet_set => l_tabdet_set
1684: ,p_table1_name => l_table1_name