APPS.CS_MULTIORG_PVT SQL Statements

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

Line: 61

    select multi_org_rule_code
        ,multi_org_rule_order
    from  cs_multi_org_rules
    order by multi_org_rule_order;

Line: 67

    SELECT b.authoring_org_id
    FROM   cs_incidents_all_b a,
           okc_k_headers_all_b b
    WHERE  a.incident_id = p_incident_id
    and    a.contract_id = b.id;

Line: 74

    SELECT a.org_id
    FROM   cs_customer_products_all a,
         cs_incidents_all_b b
    WHERE b.incident_id = p_incident_id
    AND   a.customer_product_id = b.customer_product_id;

Line: 81

    SELECT org_id
    FROM   cs_incidents_all_b
    WHERE  incident_id = p_incident_id;

Line: 86

    SELECT bill_to_site_id
          ,bill_to_account_id
     FROM cs_incidents_all_b
    WHERE incident_id = p_incident_id;

Line: 94

   SELECT org_id
     FROM hz_cust_acct_sites_all
    WHERE party_site_id   = p_party_site_id
      AND cust_account_id = p_account_id
      AND bill_to_flag    = 'P';

Line: 103

   SELECT org_id
     FROM hz_cust_acct_sites_all
    WHERE party_site_id   = p_party_site_id
      AND cust_account_id = p_account_id
      AND bill_to_flag    = 'Y';

Line: 251

    Fnd_profile.Get('CS_CHARGE_OU_UPDATE',x_profile);