DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on HR_ORGANIZATION_UNITS

Line 514: , hr_organization_units hou

510: Cursor get_organization is
511: SELECT mp.organization_id
512: , hou.NAME
513: FROM mtl_parameters mp
514: , hr_organization_units hou
515: WHERE mp.organization_code = p_organization_code
516: AND hou.organization_id = mp.organization_id;
517:
518: Cursor get_genealogy_type is

Line 685: , hr_organization_units hou

681: INTO l_current_org_code
682: , l_current_org_desc
683: , l_current_org_id
684: FROM mtl_parameters mp
685: , hr_organization_units hou
686: , mtl_lot_numbers mln
687: WHERE mln.gen_object_id = l_object_id
688: AND mp.organization_id = mln.organization_id
689: AND hou.organization_id = mln.organization_id;

Line 698: , hr_organization_units hou

694: INTO l_current_org_code
695: , l_current_org_desc
696: , l_current_org_id
697: FROM mtl_parameters mp
698: , hr_organization_units hou
699: , mtl_serial_numbers msn
700: WHERE msn.gen_object_id = l_object_id
701: AND mp.organization_id = msn.current_organization_id
702: AND hou.organization_id = msn.current_organization_id;