APPS.CN_SRP_PAYOUT_DTLS_PKG dependencies on DUAL

Line 107: FROM dual;

103: fnd_global.login_id,
104: sysdate,
105: fnd_global.user_id,
106: 1
107: FROM dual;
108:
109: END insert_row;
110:
111:

Line 164: FROM dual

160:
161: SELECT decode(p_object_version_number, mn,
162: l_old_rec.object_version_number, p_object_version_number)
163: INTO l_object_version_number
164: FROM dual
165: ;
166:
167: -- check object version number
168: IF l_object_version_number <> l_old_rec.object_version_number THEN

Line 224: FROM dual)

220: decode(p_object_version_number, mn,l_old_rec.object_version_number, p_object_version_number+1),
221: sysdate,
222: fnd_global.user_id,
223: fnd_global.login_id
224: FROM dual)
225: WHERE srp_role_id = p_srp_role_id and attain_tier_id = p_attain_tier_id
226: and attain_schedule_id = p_attain_schedule_id;
227: END update_row;
228: