APPS.AMS_ACCESS_DENORM_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 874: FROM fnd_concurrent_requests

870: AND concurrent_program_name = 'AMSADENO';
871:
872: CURSOR cur_get_latest_start_date IS
873: SELECT max(actual_start_date)
874: FROM fnd_concurrent_requests
875: WHERE program_application_id = l_program_application_id
876: AND concurrent_program_id = l_concurrent_program_id
877: AND status_code = 'C'
878: AND phase_code = 'C';

Line 1025: FROM fnd_concurrent_requests

1021: AND concurrent_program_name = 'AMSJDENO';
1022:
1023: CURSOR cur_get_latest_start_date IS
1024: SELECT MAX(actual_start_date)
1025: FROM fnd_concurrent_requests
1026: WHERE program_application_id = l_program_application_id
1027: AND concurrent_program_id = l_concurrent_program_id
1028: AND status_code = 'C'
1029: AND phase_code = 'C';

Line 1348: FROM fnd_concurrent_requests

1344: WHERE concurrent_program_name = 'AMSJDENO';
1345:
1346: CURSOR cur_get_latest_start_date IS
1347: SELECT MAX(actual_start_date)
1348: FROM fnd_concurrent_requests
1349: WHERE program_application_id = l_program_application_id
1350: AND concurrent_program_id = l_concurrent_program_id
1351: AND status_code = 'C'
1352: AND phase_code = 'C';