APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on FND_LOOKUP_VALUES_VL

Line 86: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl

82: --AGB temporay change of = to be in for bug in Business Area naming. Should change back to = before release.
83:
84: CURSOR c_horzstart_type IS SELECT value FROM zpb_ac_param_values
85: WHERE analysis_cycle_id = l_published_id
86: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl
87: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HS_TYPE');
88:
89: CURSOR c_horzend_type IS SELECT value FROM zpb_ac_param_values
90: WHERE analysis_cycle_id = l_published_id

Line 91: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl

87: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HS_TYPE');
88:
89: CURSOR c_horzend_type IS SELECT value FROM zpb_ac_param_values
90: WHERE analysis_cycle_id = l_published_id
91: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl
92: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HE_TYPE');
93:
94: CURSOR c_horzstart_mem IS SELECT value FROM zpb_ac_param_values
95: WHERE analysis_cycle_id = l_published_id

Line 96: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl

92: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HE_TYPE');
93:
94: CURSOR c_horzstart_mem IS SELECT value FROM zpb_ac_param_values
95: WHERE analysis_cycle_id = l_published_id
96: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl
97: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HS_TIME_MEMBER');
98:
99: CURSOR c_horzend_mem IS SELECT value FROM zpb_ac_param_values
100: WHERE analysis_cycle_id = l_published_id

Line 101: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl

97: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HS_TIME_MEMBER');
98:
99: CURSOR c_horzend_mem IS SELECT value FROM zpb_ac_param_values
100: WHERE analysis_cycle_id = l_published_id
101: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl
102: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HE_TIME_MEMBER');
103:
104: CURSOR c_bp_external IS SELECT value FROM zpb_ac_param_values
105: WHERE analysis_cycle_id = l_published_id

Line 107: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'

103:
104: CURSOR c_bp_external IS SELECT value FROM zpb_ac_param_values
105: WHERE analysis_cycle_id = l_published_id
106: AND param_id =
107: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
108: AND lookup_code = 'OVERRIDE_EXTERNAL_USER_CHECK');
109:
110: begin
111:

Line 210: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'

206: -- 4. has the CALENDAR_START_DATE been reached
207: SELECT value into l_bp_start FROM zpb_ac_param_values
208: WHERE analysis_cycle_id = l_published_id
209: AND param_id =
210: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
211: AND lookup_code = 'CALENDAR_START_DATE');
212:
213: --if start date is greater than sysdate the start date has not been reached.
214: if to_date(l_bp_start, 'YYYY/MM/DD HH24:MI:SS') - SYSDATE > 0 then

Line 340: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'

336: IF (l_hs_type = l_time_relative) THEN
337: SELECT value INTO l_start_lvl FROM zpb_ac_param_values
338: WHERE analysis_cycle_id = l_published_id
339: AND param_id =
340: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
341: AND lookup_code = 'CAL_HS_LEVEL');
342: END IF;
343:
344: --dbms_output.put_line('l_start_lvl=' || l_start_lvl);

Line 371: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'

367: IF (l_he_type = l_time_relative) THEN
368: SELECT value INTO l_end_lvl FROM zpb_ac_param_values
369: WHERE analysis_cycle_id = l_published_id
370: AND param_id =
371: ( SELECT tag FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
372: AND lookup_code = 'CAL_HE_LEVEL');
373: END IF;
374:
375: --dbms_output.put_line('l_end_lvl=' || l_end_lvl);