DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on HR_ORGANIZATION_UNITS

Line 510: , hr_organization_units hou

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

Line 681: , hr_organization_units hou

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;

Line 694: , hr_organization_units hou

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;