APPS.GMICCAL dependencies on IC_WHSE_STS

Line 99: FROM ic_whse_sts

95: AND UPPER(orgn_code) = UPPER(lp_co_code);
96:
97: CURSOR is_whse_closed IS
98: SELECT whse_code
99: FROM ic_whse_sts
100: WHERE whse_code = UPPER(pwhse_code)
101: AND fiscal_year = l_fiscal_yr
102: AND period = l_period
103: AND close_whse_ind <> 3;

Line 107: FROM ic_whse_sts

103: AND close_whse_ind <> 3;
104:
105: CURSOR is_whse_there IS
106: SELECT whse_code
107: FROM ic_whse_sts
108: WHERE whse_code = UPPER(pwhse_code)
109: AND fiscal_year = l_fiscal_yr
110: AND period = l_period;
111:

Line 728: UPDATE ic_whse_sts

724: /* ================================================ */
725: BEGIN
726: -- BEGIN BUG#2356476 Sastry
727: -- Also update last_updated_by,last_update_date and last_update_login.
728: UPDATE ic_whse_sts
729: SET log_end_date = SYSDATE,
730: close_whse_ind = pclose_type,
731: last_updated_by = FND_GLOBAL.USER_ID,
732: last_update_date = SYSDATE,

Line 785: FROM ic_whse_sts s, ic_whse_mst w,

781: /* Cursor Definitions
782: ================== */
783: CURSOR determine_type IS
784: SELECT s.whse_code
785: FROM ic_whse_sts s, ic_whse_mst w,
786: sy_orgn_mst o
787: WHERE o.co_code = UPPER(pco_code)
788: AND w.orgn_code = o.orgn_code
789: AND s.whse_code = w.whse_code