DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 106: -- hr_organization_information

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
110: where mp.organization_id = hoi.organization_id and

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