APPS.IEX_METRIC_CONCUR_PVT SQL Statements

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

Line: 25

    SELECT distinct p.party_id
    FROM hz_parties p, hz_cust_accounts ca
    WHERE p.status = 'A'
    AND ca.status = 'A'
    AND ca.party_id = p.party_id;

Line: 32

    SELECT ca.cust_account_id, p.party_id
    FROM hz_parties p, hz_cust_accounts ca
    WHERE p.status = 'A'
    AND ca.status = 'A'
    AND ca.party_id = p.party_id;

Line: 39

    SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
    acct_site.org_id
    FROM hz_cust_accounts ca, hz_parties p,
         hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
    WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
    AND acct_site.cust_account_id = ca.cust_account_id
    AND ca.party_id = p.party_id
    AND p.status = 'A'
    AND ca.status = 'A'
    AND acct_site.status = 'A'
    AND site_uses.status = 'A';

Line: 52

    SELECT delinquency_id, customer_site_use_id, cust_account_id, party_cust_id,org_id
    FROM iex_delinquencies
    WHERE status IN ('DELINQUENT', 'PREDELINQUENT');

Line: 59

    SELECT organization_id from hr_operating_units where
      mo_global.check_access(organization_id) = 'Y'
      AND organization_id = nvl(P_ORG_ID,organization_id);

Line: 71

    SELECT count(1)
    FROM iex_metric_summaries;

Line: 76

  l_del_sql VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';

Line: 183

          INSERT INTO iex_metric_summaries_all
	  (object_id, object_type, org_id, score_comp_type_id, metric_value,
	  creation_date, created_by, last_update_date, last_updated_by,
	  last_update_login, metric_rating)
          VALUES(l_party_id_tbl(idx1), 'PARTY',
	  --l_org_id, Moac Changes. Insert the Org_id from current set.
	  I_ORG.organization_id,
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE, G_USER_ID,
	  SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));

Line: 213

     l_party_id_tbl.DELETE;

Line: 243

          INSERT INTO iex_metric_summaries_all(object_id, object_type,
	  org_id, score_comp_type_id, metric_value, creation_date,
	  created_by, last_update_date, last_updated_by,
	  last_update_login, metric_rating)
          VALUES(l_cust_account_id_tbl(idx1), 'ACCOUNT',
	  --l_org_id, Moac Changes. Insert Org_id from current set.
	  I_ORG.organization_id,
	  l_metric_id_tbl(idx2),
	  l_metric_value_tbl(idx2), SYSDATE, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID,
	  l_metric_rating_tbl(idx2));

Line: 272

    l_cust_account_id_tbl.DELETE;

Line: 273

    l_party_id_tbl.DELETE;

Line: 308

          INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
	  score_comp_type_id, metric_value, creation_date, created_by, last_update_date,
	  last_updated_by,last_update_login, metric_rating)
          VALUES(l_site_use_id_tbl(idx1), 'BILL_TO',
	  --l_org_id,  Moac Changes. Insert Org_id from cursor.
	  l_org_id_tbl(idx1),
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE,
	  G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));

Line: 323

    l_site_use_id_tbl.DELETE;

Line: 324

    l_cust_account_id_tbl.DELETE;

Line: 325

    l_party_id_tbl.DELETE;

Line: 361

          INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
	  score_comp_type_id, metric_value, creation_date, created_by,
	  last_update_date, last_updated_by, last_update_login, metric_rating)
          VALUES(l_delinquency_id_tbl(idx1), 'DELINQUENCY',
	  --l_org_id, Moac Changes. Insert Org_id from cursor.
	  l_org_id_tbl(idx1),
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE,
	  G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));