APPS.PO_CORE_S dependencies on MTL_PARAMETERS

Line 6082: mtl_parameters mp

6078: SELECT 'Y'
6079: INTO l_in_sob
6080: FROM financials_system_parameters fsp,
6081: hr_organization_information hoi,
6082: mtl_parameters mp
6083: WHERE mp.organization_id = p_inv_org_id
6084: AND mp.organization_id = hoi.organization_id
6085: AND hoi.org_information_context = 'Accounting Information'
6086: AND hoi.org_information1 = TO_CHAR(fsp.set_of_books_id);

Line 6095: mtl_parameters mp

6091: --SQL Why: Outcome determines output parameter x_in_sob
6092: SELECT 'Y'
6093: INTO l_in_sob
6094: FROM hr_organization_information hoi,
6095: mtl_parameters mp
6096: WHERE mp.organization_id = p_inv_org_id
6097: AND mp.organization_id = hoi.organization_id
6098: AND hoi.org_information_context = 'Accounting Information'
6099: AND hoi.org_information1 = TO_CHAR(p_sob_id);

Line 6195: mtl_parameters mp

6191: --SQL Why: Return value as output parameter x_ou_id
6192: SELECT TO_NUMBER(hoi.org_information3)
6193: INTO x_ou_id
6194: FROM hr_organization_information hoi,
6195: mtl_parameters mp
6196: WHERE mp.organization_id = p_inv_org_id
6197: AND mp.organization_id = hoi.organization_id
6198: AND hoi.org_information_context = 'Accounting Information';
6199:

Line 6275: mtl_parameters mp

6271: --SQL Why: Return value as output parameter x_sob_id
6272: SELECT TO_NUMBER(hoi.org_information1)
6273: INTO x_sob_id
6274: FROM hr_organization_information hoi,
6275: mtl_parameters mp
6276: WHERE mp.organization_id = p_inv_org_id
6277: AND mp.organization_id = hoi.organization_id
6278: AND hoi.org_information_context = 'Accounting Information';
6279:

Line 6382: mtl_parameters mp,

6378: x_operating_unit_id,
6379: x_legal_entity_id
6380: FROM hr_organization_information hoi,
6381: hr_all_organization_units haou,
6382: mtl_parameters mp,
6383: gl_sets_of_books gsob
6384: WHERE mp.organization_id = p_inv_org_id
6385: AND mp.organization_id = haou.organization_id
6386: AND haou.organization_id = hoi.organization_id