DBA Data[Home] [Help]

APPS.PA_PURGE_PUB dependencies on FND_CONCURRENT_REQUESTS

Line 1187: FROM fnd_concurrent_requests)

1183: SELECT request_id
1184: FROM pa_reporting_exceptions
1185: WHERE request_id not in
1186: (SELECT request_id
1187: FROM fnd_concurrent_requests)
1188: AND nvl(request_id,0) > 0;
1189:
1190: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1191: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the

Line 1190: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,

1186: (SELECT request_id
1187: FROM fnd_concurrent_requests)
1188: AND nvl(request_id,0) > 0;
1189:
1190: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1191: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the
1192: --mass assignment flows populate this table using request_id = -1.
1193:
1194: BEGIN