APPS.WSH_WSHRDIST_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 97: MASTER_ORG_NAME ORG_ORGANIZATION_DEFINITIONS2.ORGANIZATION_NAME%TYPE;

93: RAISE;
94: END CF_SERVICE_PROVIDERFORMULA;
95:
96: FUNCTION CF_MASTER_ORGFORMULA RETURN CHAR IS
97: MASTER_ORG_NAME ORG_ORGANIZATION_DEFINITIONS2.ORGANIZATION_NAME%TYPE;
98: BEGIN
99: IF P_MASTER_ORG_ID IS NOT NULL THEN
100: SELECT
101: ORG.ORGANIZATION_NAME

Line 104: ORG_ORGANIZATION_DEFINITIONS2 ORG,

100: SELECT
101: ORG.ORGANIZATION_NAME
102: INTO MASTER_ORG_NAME
103: FROM
104: ORG_ORGANIZATION_DEFINITIONS2 ORG,
105: MTL_PARAMETERS MTL,
106: MFG_LOOKUPS A
107: WHERE NVL(ORG.DISABLE_DATE
108: ,SYSDATE + 1) > sysdate

Line 128: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

124: RAISE;
125: END CF_MASTER_ORGFORMULA;
126:
127: FUNCTION CF_ORG_NAMEFORMULA RETURN CHAR IS
128: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
129: BEGIN
130: IF P_ORGANIZATION_ID IS NOT NULL THEN
131: SELECT
132: ORGANIZATION_NAME

Line 135: ORG_ORGANIZATION_DEFINITIONS

131: SELECT
132: ORGANIZATION_NAME
133: INTO ORG_NAME
134: FROM
135: ORG_ORGANIZATION_DEFINITIONS
136: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
137: ELSE
138: ORG_NAME := ' ';
139: END IF;