APPS.JAI_DRILLDOWN_UTILS_PKG SQL Statements

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

Line: 69

  v_sql:='select count(1) from '||v_view_name||' where TRX_HDR_ID= '||to_char(v_trx_header_id);

Line: 113

  SELECT party_id
    FROM jai_rgm_dis_src_hdrs
   WHERE transfer_id = pn_transfer_id;

Line: 125

    SELECT DISTINCT transfer_number
      INTO ln_transfer_number
      FROM jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE round(jrddt.transfer_amount,2) = pn_balance
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 142

    SELECT DISTINCT transfer_number
      INTO ln_transfer_number
      FROM jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE round(jrddt.transfer_amount,2) = pn_balance

       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id

       AND jrddh.destination_party_id = pn_org_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 198

  SELECT party_id
    FROM jai_rgm_dis_src_hdrs
   WHERE transfer_id = pn_transfer_id;

Line: 203

   SELECT organization_name
     FROM org_organization_definitions
    WHERE organization_id = pn_id;

Line: 214

    SELECT DISTINCT organization_name
      INTO ln_des_org_name
      FROM jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt,
           org_organization_definitions ood

     WHERE round(jrddt.transfer_amount,2) = pn_balance
       AND jrddh.destination_party_id = ood.organization_id
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 273

  SELECT party_id
    FROM jai_rgm_dis_src_hdrs
   WHERE transfer_id = pn_transfer_id;

Line: 284

    SELECT DISTINCT ja.meaning
      INTO lv_des_org_type
      FROM ja_lookups           ja,
           jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'
       AND ja.lookup_code = jrddh.destination_party_type

       AND round(jrddt.transfer_amount,2) = pn_balance
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 302

        SELECT DISTINCT ja.meaning
      INTO lv_des_org_type
      FROM ja_lookups           ja,
           jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'
       AND ja.lookup_code = jrddh.destination_party_type

       AND round(jrddt.transfer_amount,2) = pn_balance
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrddh.destination_party_id = pn_org_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 360

  SELECT party_id
    FROM jai_rgm_dis_src_hdrs
   WHERE transfer_id = pn_transfer_id;

Line: 371

    SELECT DISTINCT hr.description
      INTO lv_des_loc_name
      FROM hr_locations         hr,
           jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE hr.location_id(+) = jrddh.location_id
       AND round(jrddt.transfer_amount,2) = pn_balance
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 387

     SELECT DISTINCT hr.description
      INTO lv_des_loc_name
      FROM hr_locations         hr,
           jai_rgm_dis_des_hdrs jrddh,
           jai_rgm_dis_src_taxes jrdst,
           jai_rgm_dis_des_taxes jrddt

     WHERE hr.location_id(+) = jrddh.location_id
       AND round(jrddt.transfer_amount,2) = pn_balance
       AND jrdst.transfer_source_id = jrddt.transfer_source_id
       AND jrdst.transfer_id = pn_transfer_id
       AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
       AND jrddh.destination_party_id = pn_org_id
       AND jrddh.transfer_id = pn_transfer_id;

Line: 437

  SELECT user_je_category_name
  INTO lv_categ_name
  FROM gl_je_categories
  WHERE je_category_name LIKE pn_categ_name;