DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 888: FROM Fnd_Concurrent_Requests FCR

884: */
885: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
886: IS
887: SELECT '1'
888: FROM Fnd_Concurrent_Requests FCR
889: WHERE FCR.argument1 = to_char(cp_customer_trx_id)
890: and fcr.status_code<> 'C'
891: and fcr.phase_code<>'C'
892: AND fcr.request_id IN (Select nvl(Max(Request_ID),-1)

Line 895: Fnd_Concurrent_Requests FCR

891: and fcr.phase_code<>'C'
892: AND fcr.request_id IN (Select nvl(Max(Request_ID),-1)
893: From Fnd_Concurrent_Programs FCP,
894: Fnd_Application FA ,
895: Fnd_Concurrent_Requests FCR
896: Where FCR.Program_Application_ID = FA.Application_ID
897: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID
898: AND FA.Application_ID = FCP.Application_ID
899: AND Concurrent_Program_Name = 'JAILINEGL'