DBA Data[Home] [Help]

APPS.BOM_CSTRPCRE_XMLP_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 149: FND_CONCURRENT_REQUESTS FCR

145: SELECT
146: MIN(FCR.REQUEST_ID)
147: INTO L_OTHER_REQUEST_ID
148: FROM
149: FND_CONCURRENT_REQUESTS FCR
150: WHERE FCR.PROGRAM_APPLICATION_ID = 702
151: AND FCR.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
152: AND FCR.ARGUMENT1 = TO_CHAR(P_ORG_ID)
153: AND FCR.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)

Line 159: FND_CONCURRENT_REQUESTS FCR2

155: AND FCR.ACTUAL_START_DATE = (
156: SELECT
157: MIN(FCR2.ACTUAL_START_DATE)
158: FROM
159: FND_CONCURRENT_REQUESTS FCR2
160: WHERE FCR2.PROGRAM_APPLICATION_ID = 702
161: AND FCR2.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
162: AND FCR2.ARGUMENT1 = TO_CHAR(P_ORG_ID)
163: AND FCR2.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)