APPS.OZF_FUND_UTILIZED_PUB SQL Statements

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

Line: 47

   SELECT 1
   FROM ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 52

   SELECT fund_id
   FROM ozf_funds_all_b
   WHERE fund_number = p_fund_num;

Line: 57

   SELECT campaign_id
   FROM  ams_campaigns_vl
   WHERE active_flag = 'Y'
     AND show_campaign_flag = 'Y'
     AND campaign_id = p_activity_id;

Line: 64

   SELECT event.event_header_id
   FROM  ams_event_headers_vl event,
         jtf_loc_hierarchies_vl loc,
         ams_act_access_denorm acc
   WHERE loc.location_type_code = 'COUNTRY'
     AND event.active_flag='Y'
     AND event.event_level='MAIN'
     AND event.event_standalone_flag='N'
     AND event.user_status_id NOT IN (6,9,7,27)
     AND TO_NUMBER(event.country_code) = loc.location_hierarchy_id
     AND acc.object_type = 'EVEH'
     AND acc.object_id = event.event_header_id
     AND acc.resource_id = p_approver_id
     AND event.event_header_id = p_activity_id;

Line: 80

   SELECT b.deliverable_id
   FROM  ams_deliverables_all_b b,
         ams_deliverables_all_tl tl,
         jtf_loc_hierarchies_vl c
   WHERE c.location_type_code = 'COUNTRY'
     AND b.active_flag='Y'
     AND c.location_hierarchy_id = b.country_id
     AND b.deliverable_id = tl.deliverable_id
     AND tl.language =userenv('LANG')
     AND b.deliverable_id = p_activity_id;

Line: 92

   SELECT list_header_id, orig_org_id
   FROM  qp_list_headers_all_b
   WHERE list_header_id = p_activity_id;

Line: 98

   SELECT offer_id
    FROM  ozf_sd_request_headers_all_b
   WHERE offer_id = p_activity_id;

Line: 103

   SELECT 1
     FROM fnd_currencies
    WHERE enabled_flag = 'Y'
      AND NVL(start_date_active, SYSDATE) <= SYSDATE
      AND NVL(end_date_active, SYSDATE) >= SYSDATE
      AND currency_code = p_curr_code;

Line: 111

   SELECT 1
   FROM  ams_campaign_schedules_vl
   WHERE campaign_id = p_activity_id;

Line: 116

   SELECT 1
   FROM  ozf_lookups
   WHERE lookup_type = 'OZF_VO_CUSTOMER_TYPES'
     AND enabled_flag = 'Y'
     AND lookup_code = p_cust_type;

Line: 123

   SELECT max(cust_account_id)
   FROM  hz_cust_accounts
   WHERE party_id = p_cust_id
     AND status= 'A';

Line: 129

   SELECT hzas.cust_account_id, hzas.org_id
   FROM  hz_cust_site_uses_all hzs,
         hz_cust_acct_sites_all hzas
   WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
     AND hzs.site_use_id = p_cust_id;

Line: 136

   SELECT hzas.cust_account_id, hzs.bill_to_site_use_id, hzas.org_id
   FROM  hz_cust_site_uses_all hzs,
         hz_cust_acct_sites_all hzas
   WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
     AND hzs.site_use_id = p_cust_id;

Line: 143

   SELECT 1
   FROM  ams_media_channels_vl med, ozf_offers off
   WHERE med.media_id = off.activity_media_id(+)
     AND qp_list_header_id = p_activity_id
     AND channel_id = p_scan_type_id;

Line: 151

   SELECT category_id
   FROM  eni_prod_den_hrchy_parents_v
   WHERE category_desc = p_prod_name
   AND NVL(category_id, 0) = category_id;*/

Line: 159

SELECT c.category_id
  FROM    mtl_default_category_sets a ,
  mtl_category_sets_b b ,
  mtl_categories_v c ,
  ENI_PROD_DEN_HRCHY_PARENTS_V d
  WHERE a.functional_area_id in (7,11)
  AND a.category_set_id = b.category_set_id
  AND b.structure_id = c.structure_id
  AND c.category_id = d.category_id(+)
  AND UPPER(NVL(d.category_desc, c.category_concat_segs)) = UPPER(p_prod_name);

Line: 171

   SELECT inventory_item_id
   FROM  mtl_system_items_kfv
    WHERE organization_id = p_org_id
    -- AND trim(padded_concatenated_segments) = p_prod_name;

Line: 178

   SELECT max(claim_type_id)
   FROM ozf_claim_types_all_vl
   WHERE adjustment_type = p_adj_type
     AND claim_class = 'ADJ'
     AND claim_type_id > -1
     AND org_id = p_org_id;

Line: 186

   SELECT adjustment_type
   FROM ozf_claim_types_all_vl
   WHERE claim_type_id = p_adj_type_id
     AND claim_class = 'ADJ'
     AND org_id = p_org_id;

Line: 194

   SELECT owner
   FROM  ozf_funds_all_vl
   WHERE fund_id = p_fund_id;

Line: 199

   SELECT currency_code_tc
   FROM    ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 205

   SELECT  1
   FROM    oe_order_lines_all
   WHERE   line_id = p_order_line_id
     AND   header_id = p_header_id;

Line: 211

   SELECT 1
   FROM hr_operating_units hr, ozf_funds_all_b fund
   WHERE fund.fund_id = p_fund_id
    AND  hr.organization_id = p_org_id
    AND  hr.set_of_books_id = fund.ledger_id;

Line: 218

   SELECT org_id
   FROM oe_order_headers_all
   WHERE header_id = p_header_id;

Line: 223

   SELECT parameter_value
    FROM  oe_sys_parameters_all
    WHERE parameter_code = 'MASTER_ORGANIZATION_ID'
      AND org_id = p_org_id;

Line: 230

   SELECT h.org_id
   FROM   oe_order_headers_all h, oe_order_lines_all l
   WHERE  h.header_id = l.header_id
   AND    l.line_id = p_order_line_id ;

Line: 236

   SELECT beneficiary_account_id,autopay_party_attr,autopay_party_id
   FROM ozf_offers
   WHERE qp_list_header_id = p_activity_id;

Line: 242

 SELECT org_id FROM ozf_resale_lines_all
 WHERE resale_line_id = p_line_id;

Line: 247

 SELECT org_id FROM po_headers_all
 WHERE po_header_id = p_header_id;

Line: 252

 SELECT org_id FROM ar_payment_schedules_all
 WHERE customer_trx_id = p_cust_trx_id;

Line: 257

  SELECT org_id
  FROM hz_cust_site_uses_all
  WHERE site_use_id = p_site_use_id;

Line: 263

   SELECT NVL(transaction_currency_code,fund_request_curr_code) fund_request_curr_code,
          transaction_currency_code
   FROM ozf_offers
   WHERE qp_list_header_id=p_activity_id;

Line: 269

   SELECT transactional_curr_code
   FROM oe_order_headers_all
   WHERE header_id = p_document_number;

Line: 274

   SELECT currency_code
   FROM ozf_resale_lines_all
   WHERE resale_line_id = p_document_number;

Line: 279

   SELECT invoice_currency_code
   FROM ra_customer_trx_all
   WHERE customer_trx_id = p_document_number;

Line: 284

   SELECT currency_code FROM po_headers_all
   WHERE po_header_id = p_document_number;

Line: 288

   SELECT oh.transactional_curr_code
   FROM oe_order_lines_all ol,  oe_order_headers_all oh
   WHERE ol.line_id = p_order_line_id
   AND ol.header_id = oh.header_id;

Line: 294

   SELECT transaction_currency_code FROM ams_campaigns_vl
   WHERE campaign_id = p_activity_id;

Line: 298

   SELECT transaction_currency_code F
   FROM ams_campaign_schedules_vl
   WHERE schedule_id = p_activity_id;

Line: 303

   SELECT transaction_currency_code
   FROM ams_deliverables_vl
   WHERE deliverable_id = p_activity_id;

Line: 308

   SELECT currency_code_tc FROM ams_event_headers_vl
   WHERE event_header_id = p_activity_id;

Line: 312

   SELECT currency_code_tc FROM ams_event_offers_vl
   WHERE event_offer_id = p_activity_id;

Line: 1136

   SELECT 1 FROM ozf_funds_all_b
   WHERE fund_id = p_fund_id
     AND fund_type = 'FULLY_ACCRUED'
     AND accrual_basis= 'CUSTOMER'
     AND liability_flag= 'Y';

Line: 1144

   SELECT org_id
   FROM  oe_order_headers_all
   WHERE header_id = p_doc_number;

Line: 1149

   SELECT org_id
   FROM  ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 1156

   SELECT utilization_id, NVL(gl_posted_flag,'N')
   FROM  ozf_funds_utilized_all_b
   WHERE plan_id = p_activity_id
     AND plan_type = p_activity_type
     AND fund_id = p_fund_id
     AND NVL(product_id,0) = NVL(p_product_id,0)
     AND NVL(cust_account_id,0) = NVL(p_cust_acct_id,0)
     AND utilization_type NOT IN ('REQUEST', 'TRANSFER');

Line: 1167

   SELECT fund_currency
   FROM ozf_object_fund_summary
   WHERE fund_id = p_fund_id
   AND object_id = p_budget_source_id
   AND object_type = p_budget_source_type;

Line: 1174

  SELECT exchange_rate_type
  FROM   ozf_sys_parameters_all
  WHERE  org_id = p_org_id;