APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_DIMENSIONS_S

Line 193: values(qpr_dimensions_s.nextval, g_new_pp_id,

189: CREATION_DATE, CREATED_BY,
190: LAST_UPDATE_DATE, LAST_UPDATED_BY,
191: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
192: PROGRAM_ID, REQUEST_ID)
193: values(qpr_dimensions_s.nextval, g_new_pp_id,
194: r_dim_val.DIM_PPA_CODE(i) ||
195: to_char(g_new_pp_id)|| '_D',
196: r_dim_val.DIM_PPA_CODE(i),
197: r_dim_val.DIM_SEQ_NUM(i),

Line 1051: from qpr_dimensions src, qpr_dimensions tmpl

1047: tmpl.NATIVE_KEY_FLAG,
1048: tmpl.MEASURE_DIM_FLAG, tmpl.SPARSE_FLAG , tmpl.LOWEST_LVL,
1049: tmpl.LIST_PRICE_PLAN_FLAG
1050: bulk collect into r_dim_val
1051: from qpr_dimensions src, qpr_dimensions tmpl
1052: where src.PRICE_PLAN_ID = p_from_pp_id
1053: and tmpl.PRICE_PLAN_ID = g_src_pplan_id
1054: and src.DIM_PPA_CODE = tmpl.DIM_PPA_CODE
1055: and nvl(tmpl.INCLUDE_FLAG, 'Y') = 'Y';