DBA Data[Home] [Help]

APPS.GMICVAL dependencies on SY_ORGN_MST

Line 1154: FROM sy_orgn_mst

1150: /* Cursor Definitions
1151: ================== */
1152: CURSOR validate_orgn IS
1153: SELECT orgn_name
1154: FROM sy_orgn_mst
1155: WHERE co_code = UPPER(porgn_code)
1156: AND orgn_code = UPPER(porgn_code)
1157: AND delete_mark = 0;
1158:

Line 1161: l_orgn_name sy_orgn_mst.orgn_name%TYPE;

1157: AND delete_mark = 0;
1158:
1159: /* Local variables.
1160: ================ */
1161: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
1162:
1163: BEGIN
1164:
1165:

Line 1222: FROM sy_orgn_mst

1218: /* Cursor Definitions
1219: ================== */
1220: CURSOR validate_orgn IS
1221: SELECT orgn_name
1222: FROM sy_orgn_mst
1223: WHERE orgn_code = UPPER(porgn_code)
1224: AND delete_mark = 0;
1225:
1226: /* Local variables.

Line 1228: l_orgn_name sy_orgn_mst.orgn_name%TYPE;

1224: AND delete_mark = 0;
1225:
1226: /* Local variables.
1227: ================ */
1228: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
1229:
1230: BEGIN
1231:
1232: