APPS.GMPMRRP dependencies on IC_WHSE_MST

Line 477: SELECT MIN(whse_code) INTO X_fwhse_code FROM ic_whse_mst;

473: FROM ps_schd_dtl
474: WHERE schedule_id = p_schedule_id;
475: BEGIN
476: IF G_fwhse_code IS NULL THEN
477: SELECT MIN(whse_code) INTO X_fwhse_code FROM ic_whse_mst;
478: ELSE
479: X_fwhse_code := G_fwhse_code;
480: END IF;
481: IF G_twhse_code IS NULL THEN

Line 482: SELECT MAX(whse_code) INTO X_twhse_code FROM ic_whse_mst;

478: ELSE
479: X_fwhse_code := G_fwhse_code;
480: END IF;
481: IF G_twhse_code IS NULL THEN
482: SELECT MAX(whse_code) INTO X_twhse_code FROM ic_whse_mst;
483: ELSE
484: X_twhse_code := G_twhse_code;
485: END IF;
486: IF G_mrp_id IS NOT NULL AND G_schedule_id IS NOT NULL THEN