506: Cursor get_organization is
507: SELECT mp.organization_id
508: , hou.NAME
509: FROM mtl_parameters mp
510: , hr_organization_units hou
511: WHERE mp.organization_code = p_organization_code
512: AND hou.organization_id = mp.organization_id;
513:
514: Cursor get_genealogy_type is
677: INTO l_current_org_code
678: , l_current_org_desc
679: , l_current_org_id
680: FROM mtl_parameters mp
681: , hr_organization_units hou
682: , mtl_lot_numbers mln
683: WHERE mln.gen_object_id = l_object_id
684: AND mp.organization_id = mln.organization_id
685: AND hou.organization_id = mln.organization_id;
690: INTO l_current_org_code
691: , l_current_org_desc
692: , l_current_org_id
693: FROM mtl_parameters mp
694: , hr_organization_units hou
695: , mtl_serial_numbers msn
696: WHERE msn.gen_object_id = l_object_id
697: AND mp.organization_id = msn.current_organization_id
698: AND hou.organization_id = msn.current_organization_id;