APPS.GR_MIGRATE_TO_12 dependencies on SY_ORGN_MST_B

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 2033: FROM sy_orgn_mst_b

2029:
2030: /* Cursor used retrieve organization id */
2031: CURSOR c_get_org_id (v_orgn_code VARCHAR2) IS
2032: SELECT organization_id
2033: FROM sy_orgn_mst_b
2034: WHERE orgn_code = v_orgn_code;
2035:
2036: /* Cursor used retrieve the records that don't have an organization id */
2037: CURSOR c_get_disp_rec IS