DBA Data[Home] [Help]

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