APPS.IBY_FNDCPT_COMMON_PUB SQL Statements

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

Line: 19

      SELECT COUNT(cust_account_id)
      FROM hz_cust_accounts
      WHERE (cust_account_id = ci_cust_acct_id)
        AND ( (party_id = ci_party_id)
            OR ci_party_id IN
              ( SELECT DISTINCT a.party_id
                FROM hz_cust_account_roles a,
                  hz_cust_accounts b, hz_party_preferences c
                WHERE (b.cust_account_id = ci_cust_acct_id)
                  AND (NVL(a.status,'A')= 'A')
                  AND (NVL(b.status, 'A') = 'A')
                  AND (a.cust_account_id = b.cust_account_id)
                  AND (a.party_id = c.party_id(+))
                  AND (c.category(+) ='PRIMARY_ACCOUNT')
                  AND (c.preference_code(+) = 'CUSTOMER_ACCOUNT_ID')
              )
            );

Line: 43

      SELECT COUNT(site_use_id)
      FROM hz_cust_site_uses_all u, hz_cust_acct_sites_all s,
        hz_cust_accounts a
      WHERE (u.site_use_id = ci_cust_site_id)
        AND (a.cust_account_id = ci_cust_acct_id)
        AND (u.cust_acct_site_id = s.cust_acct_site_id)
        AND (s.cust_account_id = a.cust_account_id);

Line: 219

      SELECT result_category, message_name
      FROM iby_result_codes
      WHERE (result_code = ci_result_code)
        AND (request_interface_code = 'FNDCPT_PUB');

Line: 269

      FND_MSG_PUB.Delete_Msg(p_prev_msg_count+1);

Line: 328

      SELECT result_category
      FROM iby_result_codes
      WHERE (result_code = ci_result)
        AND (request_interface_code = ci_interface);

Line: 351

      FND_MSG_PUB.Delete_Msg(p_prev_msg_count+1);