DBA Data[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 2107: FROM Fnd_Concurrent_Requests FCR

2103:
2104: CURSOR cur_chk_temp_lines_exist(cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE) IS
2105:
2106: SELECT '1'
2107: FROM Fnd_Concurrent_Requests FCR
2108: WHERE FCR.argument1 = to_char(cp_customer_trx_id)
2109: and fcr.status_code <> 'C'
2110: and fcr.phase_code <> 'C'
2111: AND fcr.request_id IN

Line 2115: Fnd_Concurrent_Requests FCR

2111: AND fcr.request_id IN
2112: (Select nvl(Max(Request_ID), -1)
2113: From Fnd_Concurrent_Programs FCP,
2114: Fnd_Application FA,
2115: Fnd_Concurrent_Requests FCR
2116: Where FCR.Program_Application_ID = FA.Application_ID
2117: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID
2118: AND FA.Application_ID = FCP.Application_ID
2119: AND Concurrent_Program_Name = 'JAILINEGL'