DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PER_WORKFORCE_CURRENT_X

Line 1251: FROM PER_WORKFORCE_CURRENT_X peo,

1247:
1248: WHEN S_CLM_INFO_FLAG = 'N' AND
1249: work_approver_user_name IS NOT NULL
1250: AND NOT EXISTS (SELECT 1
1251: FROM PER_WORKFORCE_CURRENT_X peo,
1252: FND_USER fu
1253: WHERE fu.user_name = work_approver_user_name
1254: AND fu.employee_id = peo.person_id
1255: AND SYSDATE >= nvl(fu.start_date, SYSDATE)