APPS.MO_GLOBAL dependencies on FND_MO_SP_PREFERENCES

Line 122: FROM fnd_mo_sp_preferences

118: -- preference setup.
119:
120: CURSOR c5 IS
121: SELECT organization_id
122: FROM fnd_mo_sp_preferences
123: WHERE USER_ID = FND_GLOBAL.USER_ID
124: AND RESP_ID = FND_GLOBAL.RESP_ID;
125:
126: l_user_id number;

Line 313: delete from FND_MO_SP_PREFERENCES_REMOTE

309: FOR m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST LOOP
310:
311: l_del_org_id := t_delete_org_id(m);
312:
313: delete from FND_MO_SP_PREFERENCES_REMOTE
314: where user_id = l_user_id
315: and resp_id = l_resp_id
316: and organization_id = l_del_org_id;
317:

Line 325: delete from FND_MO_SP_PREFERENCES

321: $end
322: else
323:
324: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
325: delete from FND_MO_SP_PREFERENCES
326: where user_id = FND_GLOBAL.USER_ID
327: and resp_id = FND_GLOBAL.RESP_ID
328: and organization_id = t_delete_org_id(m);
329: