APPS.CSI_DIAGNOSTICS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 12468: -- Get the Location ID from HR_ORGANIZATION_UNITS

12464: Exception
12465: when no_data_found then
12466: Raise Process_next;
12467: End;
12468: -- Get the Location ID from HR_ORGANIZATION_UNITS
12469: IF v_location_id IS NULL THEN
12470: Begin
12471: select location_id
12472: into v_location_id

Line 12473: from HR_ORGANIZATION_UNITS

12469: IF v_location_id IS NULL THEN
12470: Begin
12471: select location_id
12472: into v_location_id
12473: from HR_ORGANIZATION_UNITS
12474: where organization_id = organization_id_mig(i);
12475: Exception
12476: when no_data_found then
12477: Raise Process_next;

Line 12950: -- Get the Location ID from HR_ORGANIZATION_UNITS

12946: Exception
12947: when no_data_found then
12948: Raise Process_next;
12949: End;
12950: -- Get the Location ID from HR_ORGANIZATION_UNITS
12951: IF v_location_id IS NULL THEN
12952: Begin
12953: select location_id
12954: into v_location_id

Line 12955: from HR_ORGANIZATION_UNITS

12951: IF v_location_id IS NULL THEN
12952: Begin
12953: select location_id
12954: into v_location_id
12955: from HR_ORGANIZATION_UNITS
12956: where organization_id = organization_id_mig(i);
12957: Exception
12958: when no_data_found then
12959: Raise Process_next;

Line 13787: -- Get the Location ID from HR_ORGANIZATION_UNITS

13783: Exception
13784: when no_data_found then
13785: Raise Process_next;
13786: End;
13787: -- Get the Location ID from HR_ORGANIZATION_UNITS
13788: IF v_location_id IS NULL THEN
13789: Begin
13790: select location_id
13791: into v_location_id

Line 13792: from HR_ORGANIZATION_UNITS

13788: IF v_location_id IS NULL THEN
13789: Begin
13790: select location_id
13791: into v_location_id
13792: from HR_ORGANIZATION_UNITS
13793: where organization_id = organization_id_mig(i);
13794: Exception
13795: when no_data_found then
13796: Raise Process_next;