DBA Data[Home] [Help]

APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on MTL_PARAMETERS

Line 8: MTL_PARAMETERS

4: CURSOR GET_ORG_CODE IS
5: SELECT
6: ORGANIZATION_CODE
7: FROM
8: MTL_PARAMETERS
9: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
10: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
11: CURSOR GET_ORG_NAME IS
12: SELECT

Line 10: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

6: ORGANIZATION_CODE
7: FROM
8: MTL_PARAMETERS
9: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
10: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
11: CURSOR GET_ORG_NAME IS
12: SELECT
13: NAME
14: FROM

Line 161: MTL_PARAMETERS

157: CURSOR GET_ORG_CODE IS
158: SELECT
159: ORGANIZATION_CODE
160: FROM
161: MTL_PARAMETERS
162: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
163: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
164: CURSOR GET_ORG_NAME IS
165: SELECT

Line 163: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

159: ORGANIZATION_CODE
160: FROM
161: MTL_PARAMETERS
162: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
163: X_ORGANIZATION MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
164: CURSOR GET_ORG_NAME IS
165: SELECT
166: NAME
167: FROM