APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_USER

Line 1202: FND_USER fu

1198:
1199: WHEN work_approver_user_name IS NOT NULL
1200: AND NOT EXISTS (SELECT 1
1201: FROM PER_WORKFORCE_CURRENT_X peo,
1202: FND_USER fu
1203: WHERE fu.user_name = work_approver_user_name
1204: AND fu.employee_id = peo.person_id
1205: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
1206: AND SYSDATE <= nvl(fu.end_date, SYSDATE) )

Line 1286: FROM FND_USER fu

1282:
1283: UPDATE PON_ITEM_PRICES_INTERFACE pipi
1284: SET (WORK_APPROVER_USER_ID) =
1285: (SELECT fu.user_id
1286: FROM FND_USER fu
1287: WHERE pipi.work_approver_user_name = fu.user_name)
1288: WHERE batch_id = p_batch_id;
1289:
1290: END IF; -- End of if p_contract_type = 'STANDARD'