APPS.CSP_REQUIREMENT_POPULATE_PVT SQL Statements

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

Line: 25

        SELECT product_task_id,ACTUAL_TIMES_USED
        FROM   jtf_tasks_b j, CS_INCIDENTS_ALL_B i,csp_product_tasks p
        WHERE  j.task_id = l_task_id
        AND    j.SOURCE_OBJECT_TYPE_CODE = 'SR'
        AND    i.incident_id             = j.SOURCE_OBJECT_ID
        AND    p.product_id              = i.inventory_item_id
        AND    p.task_template_id        = j.template_id
        union all
        SELECT product_task_id,ACTUAL_TIMES_USED
        FROM   jtf_tasks_b jtb, csd_repairs cr,csp_product_tasks cpp
        WHERE  jtb.task_id = l_task_id
        AND    jtb.SOURCE_OBJECT_TYPE_CODE = 'DR'
        AND    cr.repair_line_id           = jtb.SOURCE_OBJECT_ID
        AND    cpp.product_id              = cr.inventory_item_id
        AND    cpp.task_template_id        = jtb.template_id;

Line: 46

        SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE
        FROM   CSP_TASK_PARTS_V
        WHERE  PRODUCT_TASK_ID = temp_product_task_id;*/

Line: 51

        SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION
        FROM   CSP_TASK_PARTS_V
        WHERE  PRODUCT_TASK_ID = temp_product_task_id
        AND   INVENTORY_ITEM_FLAG = 'Y'
        AND   NVL( trunc(START_DATE),trunc(sysdate)) <= trunc(sysdate)
        AND   NVL( trunc(END_DATE),trunc(sysdate+1)) >= trunc(sysdate);

Line: 126

                        l_requirement_header_rec.LAST_UPDATED_BY  := l_user_id ;

Line: 127

                        l_requirement_header_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 128

                        l_requirement_header_rec.LAST_UPDATE_LOGIN:= l_login_id;

Line: 147

                        select CSP_Requirement_headers_s1.nextval
                        INTO px_header_id
                        FROM DUAL;

Line: 158

                                    l_requirement_line_tbl(count1).LAST_UPDATED_BY         := l_user_id;

Line: 159

                                    l_requirement_line_tbl(count1).LAST_UPDATE_DATE        := SYSDATE ;

Line: 160

                                    l_requirement_line_tbl(count1).LAST_UPDATE_LOGIN       := l_login_id ;

Line: 174

                            l_requirement_line_tbl(count1).LAST_UPDATED_BY         := l_user_id;

Line: 175

                            l_requirement_line_tbl(count1).LAST_UPDATE_DATE        := SYSDATE ;

Line: 176

                            l_requirement_line_tbl(count1).LAST_UPDATE_LOGIN       := l_login_id ;