APPS.QA_TCA_PKG SQL Statements

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

Line: 44

            SELECT qpc.plan_id
            FROM   qa_plan_chars qpc, qa_plans qp
            WHERE  qpc.plan_id = qp.plan_id AND
                   qpc.char_id = qa_ss_const.party_name AND
                   qp.organization_id <> 0;

Line: 83

            UPDATE qa_results qr
            SET    qr.party_id               = p_to_fk_id,
                   qr.last_update_date       = sysdate,
                   qr.qa_last_update_date    = sysdate,
                   qr.last_update_login      = hz_utility_pub.last_update_login,
                   qr.last_updated_by        = hz_utility_pub.user_id,
                   qr.qa_last_updated_by     = hz_utility_pub.user_id,
                   qr.request_id             = hz_utility_pub.request_id,
                   qr.program_application_id = hz_utility_pub.program_application_id,
                   qr.program_id             = hz_utility_pub.program_id,
                   qr.program_update_date    = sysdate
            WHERE  qr.party_id = p_from_fk_id;