APPS.BIS_RG_SCHEDULES_PVT dependencies on FND_CONC_RELEASE_CLASSES

Line 1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1329: -- mdamle 08/20/2001 - Fixed SQL
1330: begin
1331: select max(schedule_id)
1332: into vScheduleId
1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1334: where s.function_name = pFunctionName
1335: and s.parameter_string = pParameters
1336: and s.concurrent_request_id = cr.request_id
1337: and cr.release_class_id = rc.release_class_id

Line 1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1357: -- mdamle 08/20/2001 - Fixed SQL
1358: begin
1359: select max(schedule_id)
1360: into vScheduleId
1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1362: where s.function_name = pFunctionName
1363: and s.parameter_string = pParameters
1364: and s.concurrent_request_id = cr.request_id
1365: and cr.release_class_id = rc.release_class_id

Line 1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1377:
1378: begin
1379: select max(schedule_id)
1380: into vScheduleId
1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1382: where s.function_name = pFunctionName
1383: -- mdamle 09/21/01 - Fixed Bug#1999262 - Added nvl
1384: and nvl(s.parameter_string, ' ') = nvl(pParameters, ' ')
1385: and s.concurrent_request_id = cr.request_id

Line 1476: from fnd_conc_release_classes rc

1472: vValidSchedule := 0;
1473: begin
1474: select count(*)
1475: into vValidSchedule
1476: from fnd_conc_release_classes rc
1477: where rc.release_class_name = pSchedule
1478: and (rc.date2 is null or rc.date2 > sysdate);
1479: end;
1480: