APPS.WSH_WSHRDIST_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS2
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