DBA Data[Home] [Help]

APPS.OZF_DRILLDOWN_PUB_PKG SQL Statements

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

Line: 86

      SELECT fund.fund_id, fund.custom_setup_id
      INTO l_fund_id, l_custom_setup_id
      FROM ozf_funds_utilized_all_b util, ozf_funds_all_b fund
      WHERE util.utilization_id = p_source_id_int_1
      AND util.fund_id = fund.fund_id;
Line: 107

         SELECT custom_setup_id, org_id
           INTO l_custom_setup_id, l_org_id
           FROM ozf_claims_all
          WHERE claim_id = p_source_id_int_1;