APPS.MSC_X_HZ_PLAN dependencies on MSC_X_HZ_UI_QUERY_ID_S

Line 4040: SELECT msc_x_hz_ui_query_id_s.nextval INTO arg_query_id FROM Dual;

4036:
4037: --massage ss and pab data
4038: --fill_ss_pab_empty_buckets;
4039: -- get the query id first
4040: SELECT msc_x_hz_ui_query_id_s.nextval INTO arg_query_id FROM Dual;
4041:
4042: -- insert the header
4043: INSERT INTO msc_hz_ui_headers
4044: (QUERY_ID,NO_OF_BUCKETS,PROD_SUM_LEVEL, ORG_SUM_LEVEL, ORG_SUM_LEVEL_TP,