DBA Data[Home] [Help]

APPS.CN_SRP_TOTAL_COMPS_PKG dependencies on DUAL

Line 103: FROM dual;

99: fnd_global.login_id,
100: sysdate,
101: fnd_global.user_id,
102: 1
103: FROM dual;
104: END insert_row;
105:
106:
107: PROCEDURE update_row

Line 158: FROM dual

154:
155: SELECT decode(p_object_version_number, mn,
156: l_old_rec.object_version_number, p_object_version_number)
157: INTO l_object_version_number
158: FROM dual
159: ;
160:
161: -- check object version number
162: IF l_object_version_number <> l_old_rec.object_version_number THEN

Line 216: FROM dual)

212: decode(p_object_version_number, mn,l_old_rec.object_version_number, p_object_version_number+1),
213: sysdate,
214: fnd_global.user_id,
215: fnd_global.login_id
216: FROM dual)
217: WHERE srp_role_id = p_srp_role_id and attain_tier_id = p_attain_tier_id
218: and attain_schedule_id = p_attain_schedule_id;
219: END update_row;
220: