APPS.OZF_FUND_UTILIZED_PUB SQL Statements

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

Line: 37

   SELECT 1
   FROM ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 42

   SELECT fund_id
   FROM ozf_funds_all_b
   WHERE fund_number = p_fund_num;

Line: 47

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

Line: 54

   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: 70

   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: 82

   SELECT qp_list_header_id
   FROM  ozf_offers
   WHERE qp_list_header_id = p_activity_id;

Line: 87

   SELECT 1
   FROM  ams_campaign_schedules_vl
   WHERE campaign_id = p_activity_id;

Line: 92

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

Line: 99

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

Line: 105

   SELECT hzas.cust_account_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: 112

   SELECT hzas.cust_account_id, hzs.bill_to_site_use_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: 119

   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: 127

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

Line: 133

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

Line: 139

   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;

Line: 146

   SELECT owner
   FROM  ozf_funds_all_vl
   WHERE fund_id = p_fund_id;

Line: 151

   SELECT currency_code_tc
   FROM    ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 157

   SELECT  1
   FROM    oe_order_headers_all a
         , oe_order_lines_all b
   WHERE   b.line_id = p_order_line_id
     AND   a.header_id = b.header_id;

Line: 533

   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: 540

   SELECT org_id
   FROM  oe_order_headers_all
   WHERE header_id = p_doc_number;

Line: 545

   SELECT org_id
   FROM  ozf_funds_all_b
   WHERE fund_id = p_fund_id;

Line: 551

   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');