505: l_org_desc VARCHAR2(240);
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:
676: , mln.organization_id
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
689: , msn.current_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
1975: ;
1976:
1977: Cursor get_org is
1978: SELECT mp.organization_code
1979: FROM mtl_parameters mp
1980: WHERE mp.organization_id = p_quality_samples_rec.current_org_id
1981: ;
1982:
1983: Cursor get_samples_parent is