APPS.PO_CORE_S dependencies on MTL_PARAMETERS

Line 5874: mtl_parameters mp

5870: SELECT 'Y'
5871: INTO l_in_sob
5872: FROM financials_system_parameters fsp,
5873: hr_organization_information hoi,
5874: mtl_parameters mp
5875: WHERE mp.organization_id = p_inv_org_id
5876: AND mp.organization_id = hoi.organization_id
5877: AND hoi.org_information_context = 'Accounting Information'
5878: AND hoi.org_information1 = TO_CHAR(fsp.set_of_books_id);

Line 5887: mtl_parameters mp

5883: --SQL Why: Outcome determines output parameter x_in_sob
5884: SELECT 'Y'
5885: INTO l_in_sob
5886: FROM hr_organization_information hoi,
5887: mtl_parameters mp
5888: WHERE mp.organization_id = p_inv_org_id
5889: AND mp.organization_id = hoi.organization_id
5890: AND hoi.org_information_context = 'Accounting Information'
5891: AND hoi.org_information1 = TO_CHAR(p_sob_id);

Line 5987: mtl_parameters mp

5983: --SQL Why: Return value as output parameter x_ou_id
5984: SELECT TO_NUMBER(hoi.org_information3)
5985: INTO x_ou_id
5986: FROM hr_organization_information hoi,
5987: mtl_parameters mp
5988: WHERE mp.organization_id = p_inv_org_id
5989: AND mp.organization_id = hoi.organization_id
5990: AND hoi.org_information_context = 'Accounting Information';
5991:

Line 6067: mtl_parameters mp

6063: --SQL Why: Return value as output parameter x_sob_id
6064: SELECT TO_NUMBER(hoi.org_information1)
6065: INTO x_sob_id
6066: FROM hr_organization_information hoi,
6067: mtl_parameters mp
6068: WHERE mp.organization_id = p_inv_org_id
6069: AND mp.organization_id = hoi.organization_id
6070: AND hoi.org_information_context = 'Accounting Information';
6071:

Line 6174: mtl_parameters mp,

6170: x_operating_unit_id,
6171: x_legal_entity_id
6172: FROM hr_organization_information hoi,
6173: hr_all_organization_units haou,
6174: mtl_parameters mp,
6175: gl_sets_of_books gsob
6176: WHERE mp.organization_id = p_inv_org_id
6177: AND mp.organization_id = haou.organization_id
6178: AND haou.organization_id = hoi.organization_id