APPS.OZF_CLAIM_TAX_PVT SQL Statements

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

Line: 100

  SELECT
	 oc.set_of_books_id
  ,	 oc.claim_class
  ,	 oc.currency_code
  ,	 fc.precision
  ,	 oc.payment_method
  ,	 oc.exchange_rate_type
  ,	 oc.exchange_rate_date
  ,	 oc.exchange_rate
  ,	 oc.org_id
  FROM ozf_claims oc
  ,    fnd_currencies fc
  WHERE	oc.currency_code = fc.currency_code
  AND	  oc.claim_id	   = cv_claim_id;

Line: 117

 SELECT	 tax_for
   FROM	  ozf_claim_sttlmnt_methods_all	 ssm
	     , ozf_claims_all oc
WHERE	ssm.settlement_method =	oc.payment_method
    AND	   ssm.claim_class = oc.claim_class
    AND	   NVL(ssm.source_object_class,	'_NULL_') = NVL(oc.source_object_class,	'_NULL_')
    AND	   ssm.org_id =	oc.org_id
    AND	   oc.claim_id	= p_claim_id;

Line: 129

  SELECT  gs.currency_code
  FROM	   gl_sets_of_books gs
  ,		ozf_sys_parameters org
  WHERE	 org.set_of_books_id = gs.set_of_books_id
  AND	 org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

Line: 138

  SELECT  minimum_accountable_unit,
		precision
    FROM  fnd_currencies
  WHERE	currency_code =	p_curr_code
      AND  NVL(enabled_flag,'N') = 'Y';

Line: 145

   SELECT  cm_trx_type_id,
		 dm_trx_type_id
      FROM  ozf_claim_types_all_b
    WHERE  claim_type_id = p_claim_type_id;

Line: 154

    SELECT  party_site.party_site_id,
		  party_site.location_id
      FROM   hz_cust_site_uses_all   cust_site_use,
		  hz_cust_acct_sites_all  cust_site,
		  hz_party_sites	  party_site
    WHERE  site_use_id = p_cust_acct_site_use_id
	AND   cust_site.cust_acct_site_id = cust_site_use.cust_acct_site_id
	AND   cust_site.party_site_id	  = party_site.party_site_id;

Line: 164

   SELECT  party_site_id,
		 location_id
     FROM   po_vendor_sites
  WHERE	   vendor_site_id = p_vendor_site_id;

Line: 170

 SELECT	 ship_to_location_id
    FROM  ap_supplier_sites_all
  WHERE	 vendor_site_id	= l_claim_header.vendor_site_id;

Line: 180

 SELECT	 SUM(DECODE(tax_amt_included_flag, 'Y',0, tax_amt_tax_curr)),
	       SUM(DECODE(tax_amt_included_flag, 'Y',0,	tax_amt_funcl_curr))
   FROM	  zx_detail_tax_lines_gt
  WHERE	 internal_organization_id = p_org_id
    AND	 application_id	= p_application_id
    AND	 entity_code = p_entity_code
    AND	 event_class_code = p_event_class_code
    AND	 trx_id	= p_claim_id
    AND	 trx_line_id = p_claim_line_id;