DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on MTL_PARAMETERS

Line 105: -- replace org_organization_definitions with mtl_parameters and

101: /* Derive Trading_Partner_Id based on Trading_Partner_code */
102:
103: BEGIN
104: -- performance repository bug 4891939
105: -- replace org_organization_definitions with mtl_parameters and
106: -- hr_organization_information
107: SELECT mp.organization_id
108: INTO x_trading_partner_ID
109: from mtl_parameters mp, hr_organization_information hoi

Line 109: from mtl_parameters mp, hr_organization_information hoi

105: -- replace org_organization_definitions with mtl_parameters and
106: -- hr_organization_information
107: SELECT mp.organization_id
108: INTO x_trading_partner_ID
109: from mtl_parameters mp, hr_organization_information hoi
110: where mp.organization_id = hoi.organization_id and
111: hoi.org_information1 = 'INV' and
112: hoi.org_information2 = 'Y' and
113: hoi.org_information_context = 'CLASS' and