DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_USER

Line 1252: FND_USER fu

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)
1256: AND SYSDATE <= nvl(fu.end_date, SYSDATE) )

Line 1337: FROM FND_USER fu

1333:
1334: UPDATE PON_ITEM_PRICES_INTERFACE pipi
1335: SET (WORK_APPROVER_USER_ID) =
1336: (SELECT fu.user_id
1337: FROM FND_USER fu
1338: WHERE pipi.work_approver_user_name = fu.user_name)
1339: WHERE batch_id = p_batch_id;
1340:
1341: END IF; -- End of if p_contract_type = 'STANDARD'