APPS.PA_PACRCAPS_XMLP_PKG SQL Statements

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

Line: 37

    SELECT  gl.name
    INTO    cp_company_name
    FROM    gl_sets_of_books gl,pa_implementations pi
    WHERE   gl.set_of_books_id = pi.set_of_books_id;

Line: 45

             SELECT  segment1
             INTO    CP_PROJECT_NUMBER
             FROM    pa_projects_all
             WHERE   project_id=p_project_id;

Line: 59

             SELECT  name
             INTO    CP_PROJECT_ORG
             FROM    pa_organizations_proj_all_bg_v
             WHERE   organization_id=p_project_org;