APPS.GMICCAL dependencies on IC_WHSE_MST

Line 22: ic_whse_mst.whse_code%TYPE;

18: dd-mmm-yyyy hh24:mi:ss
19: porgn_code - organization code of type
20: ic_cldr_dtl.orgn_code%TYPE;
21: pwhse_code - warehouse code of type
22: ic_whse_mst.whse_code%TYPE;
23:
24: RETURNS:
25: <-29 RDBMS Oracle Error.
26: -29 Warehouse code is not found.

Line 114: FROM ic_whse_mst

110: AND period = l_period;
111:
112: CURSOR validate_whse IS
113: SELECT whse_code
114: FROM ic_whse_mst
115: where whse_code = UPPER(pwhse_code)
116: AND delete_mark = 0;
117:
118: CURSOR get_whse_orgn_code IS

Line 120: FROM ic_whse_mst

116: AND delete_mark = 0;
117:
118: CURSOR get_whse_orgn_code IS
119: SELECT orgn_code
120: FROM ic_whse_mst
121: where whse_code = UPPER(pwhse_code);
122: --no need for checking the delete mark here
123: /* ================================================ */
124: BEGIN

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