DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_MAIN dependencies on FND_CONCURRENT_REQUESTS

Line 2872: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c

2868: else
2869: if nvl(PJI_UTILS.GET_PARAMETER('PJI_STAGE3_REQ_LUPPD'),'Y') = 'N' then
2870: Select Max(Request_ID)
2871: Into l_req_id1
2872: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c
2873: Where a.Program_Application_ID = P.Application_ID
2874: And a.Concurrent_Program_ID = P.Concurrent_Program_ID
2875: AND P.Concurrent_Program_Name = 'PJI_PJP_LAUNCH_UPP_PRG'
2876: And P.Application_ID = c.Application_ID

Line 2881: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c

2877: And c.Application_Short_Name = 'PJI';
2878:
2879: Select Max(Request_ID)
2880: Into l_req_id2
2881: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c
2882: Where a.Program_Application_ID = P.Application_ID
2883: And a.Concurrent_Program_ID = P.Concurrent_Program_ID
2884: AND P.Concurrent_Program_Name = 'PJI_PJP_LAUNCH_RPP_PRG'
2885: And P.Application_ID = c.Application_ID