APPS.GR_MIGRATE_TO_12 dependencies on SY_ORGN_MST

Line 329: FROM sy_orgn_mst_b

325: /* ------------------ CURSORS ---------------------- */
326: /* Cursor used retrieve the master organizations that will track Regulatory data */
327: CURSOR c_get_master_orgs IS
328: SELECT organization_id
329: FROM sy_orgn_mst_b
330: WHERE master_organization_id IS NULL and
331: regulatory_org_ind = 'Y'and
332: organization_id is not null; --in case the org is not migrated then this indicates that
333:

Line 337: FROM sy_orgn_mst_b

333:
334: /* Cursor used retrieve the child organizations that will track Regulatory data */
335: CURSOR c_get_child_orgs IS
336: SELECT organization_id
337: FROM sy_orgn_mst_b
338: WHERE master_organization_id IS NOT NULL and
339: regulatory_org_ind = 'Y' and
340: organization_id is not null;
341:

Line 1242: l_owner_org sy_orgn_mst.orgn_code%TYPE;

1238: l_exists_count NUMBER := 0;
1239: l_item_code VARCHAR2(32);
1240: l_uom_type sy_uoms_typ.um_type%TYPE;
1241: l_uom VARCHAR2(4);
1242: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1243: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1244: l_inventory_item_id NUMBER;
1245: l_text VARCHAR2(80);
1246: l_line_no NUMBER;

Line 1243: l_owner_org_id sy_orgn_mst.organization_id%TYPE;

1239: l_item_code VARCHAR2(32);
1240: l_uom_type sy_uoms_typ.um_type%TYPE;
1241: l_uom VARCHAR2(4);
1242: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1243: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1244: l_inventory_item_id NUMBER;
1245: l_text VARCHAR2(80);
1246: l_line_no NUMBER;
1247: l_formula_id NUMBER;

Line 1310: FROM sy_orgn_mst

1306:
1307: /* Cursor used to retrieve organization_id */
1308: CURSOR c_get_organization_id (v_org_code VARCHAR2) IS
1309: SELECT organization_id
1310: FROM sy_orgn_mst
1311: WHERE orgn_code = v_org_code;
1312:
1313: /* Cursor used to retrieve items primary_uom */
1314: CURSOR c_get_primary_uom (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS

Line 2009: FROM sy_orgn_mst_b

2005:
2006: /* Cursor used retrieve organization id */
2007: CURSOR c_get_org_id (v_orgn_code VARCHAR2) IS
2008: SELECT organization_id
2009: FROM sy_orgn_mst_b
2010: WHERE orgn_code = v_orgn_code;
2011:
2012: /* Cursor used retrieve the records that don't have an organization id */
2013: CURSOR c_get_disp_rec IS