DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PER_WORKFORCE_CURRENT_X

Line 5304: FROM PER_WORKFORCE_CURRENT_X peo,

5300:
5301: INSERT ALL
5302: WHEN work_approver_user_id IS NOT NULL
5303: AND NOT EXISTS (SELECT 1
5304: FROM PER_WORKFORCE_CURRENT_X peo,
5305: FND_USER fu
5306: WHERE fu.user_id = work_approver_user_id
5307: AND fu.employee_id = peo.person_id
5308: AND SYSDATE >= nvl(fu.start_date, SYSDATE)

Line 5881: FROM PER_WORKFORCE_CURRENT_X peo,

5877: p_user_id, SYSDATE, p_login_id -- 8
5878: )
5879: WHEN work_approver_user_id IS NOT NULL
5880: AND NOT EXISTS (SELECT 1
5881: FROM PER_WORKFORCE_CURRENT_X peo,
5882: FND_USER fu
5883: WHERE fu.user_id = work_approver_user_id
5884: AND fu.employee_id = peo.person_id
5885: AND SYSDATE >= nvl(fu.start_date, SYSDATE)