APPS.GMD_NPD_MIGRATE dependencies on SY_ORGN_MST

Line 87: FROM sy_orgn_mst

83: CURSOR Cur_get_plant_lab_ind IS
84: SELECT orgn_code, plant_ind, organization_id, created_by,
85: Last_updated_by, creation_date, last_update_date,
86: Last_update_login
87: FROM sy_orgn_mst
88: WHERE plant_ind > 0
89: AND delete_mark = 0
90: AND migrated_ind = 1;
91:

Line 1185: FROM sy_orgn_mst_b

1181: P_commit IN VARCHAR2,
1182: X_failure_count OUT NOCOPY NUMBER) IS
1183: CURSOR Cur_get_orgn (V_orgn_code VARCHAR2) IS
1184: SELECT organization_id
1185: FROM sy_orgn_mst_b
1186: WHERE orgn_code = V_orgn_code
1187: AND migrated_ind = 1;
1188:
1189: l_profile_value VARCHAR2(80);