APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 140: -- hr_organization_information

136:
137: BEGIN
138: -- performance repository bug 4891939
139: -- replace org_organization_definitions with mtl_parameters and
140: -- hr_organization_information
141: -- LSP PROJECT : get party_id value for the given client_id(cust_accnt_id)
142: IF (p_client_code IS NULL) THEN
143: --{
144: SELECT mp.organization_id

Line 146: FROM mtl_parameters mp, hr_organization_information hoi

142: IF (p_client_code IS NULL) THEN
143: --{
144: SELECT mp.organization_id
145: INTO x_trading_partner_ID
146: FROM mtl_parameters mp, hr_organization_information hoi
147: WHERE mp.organization_id = hoi.organization_id and
148: hoi.org_information1 = 'INV' and
149: hoi.org_information2 = 'Y' and
150: hoi.org_information_context = 'CLASS' and