[Home] [Help]
292: customer_id, task_id, cta_user_dim1_id, cta_user_dim2_id,
293: cta_user_dim3_id, cta_user_dim4_id, cta_user_dim5_id,
294: cta_user_dim6_id, cta_user_dim7_id, cta_user_dim8_id,
295: cta_user_dim9_id, cta_user_dim10_id
296: FROM gcs_curr_treatments_b ctb
297: WHERE curr_treatment_id = c_curr_treatment_id;
298:
299: -- Used to obtain entity information for the parent
300: CURSOR entity_c(c_entity_id NUMBER, c_hierarchy_id NUMBER) IS
502: 'customer_id, task_id, cta_user_dim1_id, cta_user_dim2_id, ' ||
503: 'cta_user_dim3_id, cta_user_dim4_id, cta_user_dim5_id, cta_user_dim6_id, ' ||
504: 'cta_user_dim7_id, cta_user_dim8_id, cta_user_dim9_id, ' ||
505: 'cta_user_dim10_id' || g_nl ||
506: 'FROM gcs_curr_treatments_b ctb' || g_nl ||
507: 'WHERE curr_treatment_id = ' || x_curr_treatment_id);
508:
509: -- Get information on the currency_treatment.
510: OPEN curr_treatment_c(x_curr_treatment_id);