[Home] [Help]
6077: --SQL Why: Outcome determines output parameter x_in_sob
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'
6090: --SQL What: Check if inv org p_inv_org_id is in SOB p_sob_id
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'
6190: --SQL What: Get the operating unit associated with p_inv_org_id
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';
6270: --SQL What: Get the set of books ID associated with p_inv_org_id
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';
6376: x_set_of_books_id,
6377: x_chart_of_accounts_id,
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