DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PER_WORKFORCE_CURRENT_X

Line 6158: FROM PER_WORKFORCE_CURRENT_X peo,

6154:
6155: INSERT ALL
6156: WHEN work_approver_user_id IS NOT NULL
6157: AND NOT EXISTS (SELECT 1
6158: FROM PER_WORKFORCE_CURRENT_X peo,
6159: FND_USER fu
6160: WHERE fu.user_id = work_approver_user_id
6161: AND fu.employee_id = peo.person_id
6162: AND SYSDATE >= nvl(fu.start_date, SYSDATE)

Line 6737: FROM PER_WORKFORCE_CURRENT_X peo,

6733: p_user_id, SYSDATE, p_login_id -- 8
6734: )
6735: WHEN work_approver_user_id IS NOT NULL
6736: AND NOT EXISTS (SELECT 1
6737: FROM PER_WORKFORCE_CURRENT_X peo,
6738: FND_USER fu
6739: WHERE fu.user_id = work_approver_user_id
6740: AND fu.employee_id = peo.person_id
6741: AND SYSDATE >= nvl(fu.start_date, SYSDATE)