APPS.MSC_X_HZ_PLAN dependencies on MSC_X_HZ_UI_QUERY_ID_S

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

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