APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on ZPB_AC_PARAM_VALUES

Line 84: CURSOR c_horzstart_type IS SELECT value FROM zpb_ac_param_values

80: from zPB_BUSINESS_AREAS_VL where name = p_ba_name);
81:
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:

Line 89: CURSOR c_horzend_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
91: AND param_id = ( SELECT tag FROM fnd_lookup_values_vl
92: WHERE LOOKUP_TYPE = 'ZPB_PARAMS' AND lookup_code = 'CAL_HE_TYPE');
93:

Line 94: CURSOR c_horzstart_mem 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
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:

Line 99: CURSOR c_horzend_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
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:

Line 104: CURSOR c_bp_external 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
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');

Line 207: SELECT value into l_bp_start FROM zpb_ac_param_values

203: CLOSE c_horzend_mem;
204: END IF;
205:
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');

Line 337: SELECT value INTO l_start_lvl FROM zpb_ac_param_values

333:
334:
335: -- validate the BP for solve compliance, start horizon
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');

Line 368: SELECT value INTO l_end_lvl FROM zpb_ac_param_values

364: END IF;
365:
366: -- validate the BP for solve compliance, end horizon
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');