APPS.PV_PARTNER_ACCNT_MGMT_PVT SQL Statements

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

Line: 28

    SELECT party_name, party_number
    FROM  hz_parties
    WHERE party_id = l_party_id
    AND   party_type = 'ORGANIZATION';

Line: 83

    SELECT generate_customer_number INTO l_gen_cust_num FROM ar_system_parameters;

Line: 194

     SELECT cust_acct_site_id
     FROM hz_cust_acct_sites
     WHERE cust_account_id = l_Account_Id
     AND party_site_id    = l_Site_Id;

Line: 441

         SELECT site_use_id
         FROM hz_cust_site_uses
         WHERE cust_acct_site_id = l_acct_site_id
         AND site_use_code = l_site_type;

Line: 447

         SELECT party_site_use_id
         FROM hz_party_site_uses
         WHERE party_site_id = l_party_site_id
         AND site_use_type = l_Site_type;

Line: 453

        Select hzl.city
        From hz_locations hzl,hz_party_sites hps
        Where hps.party_site_id = l_party_site_id
        And hzl.location_id = hps.location_id;

Line: 544

        SELECT AUTO_SITE_NUMBERING INTO l_profile FROM AR_SYSTEM_PARAMETERS;

Line: 701

   SELECT responsibility_id
   FROM hz_role_responsibility
   WHERE cust_account_role_id = role_id
   AND responsibility_type = resp_type;

Line: 858

     SELECT cust_account_id
     FROM hz_cust_accounts
     WHERE party_id = l_Party_Id
     and status = 'A';

Line: 936

  select a.site_use_id, a.cust_acct_site_id
  from hz_cust_site_uses a, hz_cust_acct_sites b
  where b.cust_account_id = p_cust_account_id
  and b.party_site_id = p_party_site_id
  and a.cust_acct_site_id = b.cust_acct_site_id
  and a.site_use_code = p_acct_site_type
  and a.status = 'A'
  and b.status = 'A';

Line: 1011

 select a.cust_account_role_id
 from hz_cust_account_roles a,  hz_cust_acct_sites c
 where a.role_type = 'CONTACT'
 and a.party_id = p_contact_party_id
 and a.cust_account_id = p_cust_account_id
 and a.cust_acct_site_id = c.cust_acct_site_id
 and c.cust_acct_site_id = p_cust_account_site_id
 and a.cust_account_id = c.cust_account_id
 and c.status = 'A'
 and a.status = 'A';

Line: 1098

        SELECT site_use_type_id FROM HZ_SITE_USE_TYPES
        WHERE name = p_type_name;*/