APPS.PQH_CONTEXT SQL Statements

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

Line: 20

             select context
                  , transaction_short_name
                  , application_short_name
                  , responsibility_key
                  , legislation_code
             from pqh_copy_entity_contexts cec
             where context                = p_context
             ;

Line: 32

             select context
             from pqh_copy_entity_contexts cec
             where transaction_short_name = p_txn_short_name
             and   context               <> p_current_context
             and   application_short_name IS NULL
             and   responsibility_key     IS NULL
             and   legislation_code       IS NULL
             ;

Line: 45

             select context
             from pqh_copy_entity_contexts cec
             where transaction_short_name = p_txn_short_name
             and   application_short_name = p_app_short_name
             and   context               <> p_current_context
             and   responsibility_key     IS NULL
             and   legislation_code       IS NULL
             ;

Line: 59

             select context
             from pqh_copy_entity_contexts cec
             where transaction_short_name = p_txn_short_name
             and   application_short_name = p_app_short_name
             and   responsibility_key     = p_resp_key
             and   context               <> p_current_context
             and   legislation_code       IS NULL
             ;

Line: 73

             select context
             from pqh_copy_entity_contexts cec
             where transaction_short_name = p_txn_short_name
             and   application_short_name = p_app_short_name
             and   legislation_code       = p_legis_code
             and   context               <> p_current_context
             and   responsibility_key     IS NULL
             ;