DBA Data[Home] [Help]

APPS.AMW_PROJECT_EVENT_PVT dependencies on DUAL

Line 174: from dual;

170:
171:
172: select decode(l_prev_eval, null, 1, 0)
173: into l_evaluated_diff
174: from dual;
175:
176: select decode(l_new_eval,
177: l_prev_eval, 0,
178: 'EFFECTIVE', decode(l_prev_eval, null, 0, -1),

Line 181: from dual;

177: l_prev_eval, 0,
178: 'EFFECTIVE', decode(l_prev_eval, null, 0, -1),
179: decode(l_prev_eval, 'EFFECTIVE', 1, null, 1, 0))
180: into l_ineff_diff
181: from dual;
182:
183: IF l_obj_name = 'AMW_ORGANIZATION' THEN
184: UPDATE amw_audit_scope_organizations
185: SET last_update_date = sysdate,

Line 876: FROM dual;

872: g_user_id,
873: sysdate,
874: g_login_id,
875: 1
876: FROM dual;
877: END IF;
878:
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN