DBA Data[Home] [Help]

APPS.PA_PURGE_PUB dependencies on FND_CONCURRENT_REQUESTS

Line 1168: FROM fnd_concurrent_requests)

1164: SELECT request_id
1165: FROM pa_reporting_exceptions
1166: WHERE request_id not in
1167: (SELECT request_id
1168: FROM fnd_concurrent_requests)
1169: AND nvl(request_id,0) > 0;
1170:
1171: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1172: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the

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

1167: (SELECT request_id
1168: FROM fnd_concurrent_requests)
1169: AND nvl(request_id,0) > 0;
1170:
1171: --Technically if the pa_reporting_exceptions.request_id does not exist in fnd_concurrent_requests.request_id,
1172: --then the record is eligible to be purged. Note - the code must exclude request_id < 0 as the
1173: --mass assignment flows populate this table using request_id = -1.
1174:
1175: BEGIN