DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 2450: FROM FND_CONCURRENT_REQUESTS fcr, FND_CONCURRENT_PROGRAMS_TL fcp

2446: FROM OE_CREDIT_CHECK_RULES
2447: WHERE QUICK_CR_CHECK_FLAG = 'Y';
2448: SELECT COUNT(fcr.REQUEST_ID)
2449: INTO creqcnt
2450: FROM FND_CONCURRENT_REQUESTS fcr, FND_CONCURRENT_PROGRAMS_TL fcp
2451: WHERE fcr.CONCURRENT_PROGRAM_ID=fcp.concurrent_program_id
2452: AND (( fcr.PHASE_CODE='P' AND fcr.STATUS_CODE='Q'
2453: OR fcr.PHASE_CODE='P' AND fcr.STATUS_CODE='R' )
2454: OR ( fcr.PHASE_CODE='R' AND fcr.STATUS_CODE='R' ))