[Home] [Help]
5869: --SQL Why: Outcome determines output parameter x_in_sob
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'
5882: --SQL What: Check if inv org p_inv_org_id is in SOB p_sob_id
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'
5982: --SQL What: Get the operating unit associated with p_inv_org_id
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';
6062: --SQL What: Get the set of books ID associated with p_inv_org_id
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';
6168: x_set_of_books_id,
6169: x_chart_of_accounts_id,
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