DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 1359: from OZF_SD_BATCH_HEADERS_ALL bh, FND_CONCURRENT_PROGRAMS cp , FND_CONCURRENT_REQUESTS cr

1355: l_phase_code VARCHAR2(1) := NULL;
1356:
1357: Cursor c_pen_close_batches (p_batch_id number) is
1358: select bh.status_code, cr.request_id, cr.phase_code
1359: from OZF_SD_BATCH_HEADERS_ALL bh, FND_CONCURRENT_PROGRAMS cp , FND_CONCURRENT_REQUESTS cr
1360: where cp.concurrent_program_name = 'OZFSDPBPPRG'
1361: and cp.concurrent_program_id = bh.program_id
1362: and cr.request_id(+) = bh.request_id
1363: and bh.batch_id = p_batch_id;