APPS.AD_PA_MISC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

SELECT job_name,
       start_time,
       end_time
BULK COLLECT INTO l_job_name,
                  l_start_time,
                  l_end_time
FROM   ad_program_run_task_jobs
WHERE program_run_id=prid
AND   task_status_id=tsid
AND   phase_name=pname
AND   (product=prd OR
       (product='java' AND ((arguments like '%fullpath:'||prd||':%') OR
                           (arguments like '%fullpath_'||prd||'_%') OR
                           (arguments like '%'||UPPER(prd)||'_TOP%'))))
ORDER BY start_time;

Line: 101

SELECT job_name,
       start_time,
       end_time
BULK COLLECT INTO l_job_name,
                  l_start_time,
                  l_end_time
FROM   ad_task_timing
WHERE session_id=ssid
AND   phase_name=pname
AND   (product=prd OR
       (product='java' AND ((arguments like '%fullpath:'||prd||':%') OR
                           (arguments like '%fullpath_'||prd||'_%') OR
                           (arguments like '%'||UPPER(prd)||'_TOP%'))))
ORDER BY start_time;

Line: 117

SELECT job_name,
       start_time,
       end_time
BULK COLLECT INTO l_job_name,
                  l_start_time,
                  l_end_time
FROM   ad_task_timing
WHERE session_id=ssid
AND   phase_name=pname
AND   prd=NVL(DECODE(product,
                     'java',
                     regexp_substr(
                            regexp_substr(
                                   regexp_substr(arguments,
                                                 'fullpath[:|_](\w+)[:|_]'),
                                    ':\w+:'),
                                 '\w+'),
                             product), NVL(lower(
                                               regexp_substr(
                                                 regexp_substr(arguments,
                                                               '[A-Z]+_TOP'),
                                              '[A-Z]+')), product))
ORDER BY start_time;