DBA Data[Home] [Help]

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: BEGIN

Line 299: delete from FND_MO_SP_PREFERENCES

295: END LOOP;
296: -- IF t_delete_org_id.COUNT <> t_pref_org_id.COUNT THEN
297: IF (t_delete_org_id.COUNT > 0) THEN
298: FORALL m IN t_delete_org_id.FIRST .. t_delete_org_id.LAST
299: delete from FND_MO_SP_PREFERENCES
300: where user_id = FND_GLOBAL.USER_ID
301: and resp_id = FND_GLOBAL.RESP_ID
302: and organization_id = t_delete_org_id(m);
303: commit;