APPS.JL_ZZ_SYS_OPTIONS_PKG SQL Statements

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

Line: 59

            Select global_attribute6
              Into   x_payment_action
              From   ap_system_parameters_all
              Where  nvl(org_id,-99) = nvl(p_org_id,-99);

Line: 89

            Select global_attribute3
              Into   x_payment_action
              From   ar_system_parameters_all
              Where  nvl(org_id,-99) = nvl(p_org_id,-99);

Line: 119

            Select global_attribute7
              Into   x_payment_location
              From   ap_system_parameters_all
              Where  nvl(org_id,-99) = nvl(p_org_id,-99);

Line: 167

              Select global_attribute19
              Into   x_tx_use_wh_oper
              From   ar_system_parameters_all
              Where  nvl(org_id,-99) = nvl(p_org_id,-99);

Line: 197

            Select global_attribute8
              Into   x_change_date_automatically
              From   ap_system_parameters_all
              Where  nvl(org_id,-99) = nvl(p_org_id,-99);