516: INTO l_user_id
517: FROM hz_parties hzp,
518: fnd_user u,
519: per_all_people_f pap,
520: (SELECT fnd_global.user_id() AS
521: user_id
522: FROM dual)
523: curr
524: WHERE curr.user_id = u.user_id
1239: INTO l_user_id
1240: FROM hz_parties hzp,
1241: fnd_user u,
1242: per_all_people_f pap,
1243: (SELECT fnd_global.user_id() AS
1244: user_id
1245: FROM dual)
1246: curr
1247: WHERE curr.user_id = u.user_id