APPS.AD_PA_SUBMIT_REQUEST SQL Statements

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

Line: 569

    SELECT fnd_global.conc_request_id INTO l_request_id from dual;

Line: 574

    SELECT parent_request_id INTO l_request_set_id FROM fnd_concurrent_requests
    WHERE request_id =
     ( SELECT  parent_request_id
       FROM    fnd_concurrent_requests
       WHERE request_id = l_request_id );

Line: 658

        SELECT bug_number, baseline
        INTO l_bugnum, l_baseline
        FROM ad_pm_patches
        WHERE patch_id = patchid;