APPS.CE_PARTY_MERGE_PKG SQL Statements

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

Line: 43

  SELECT count(*)
  INTO  x_party_count
  FROM HZ_PARTY_USG_ASSIGNMENTS
  where  party_id =  p_From_FK_id --p_from_id
  and PARTY_USAGE_CODE in ('BANK', 'CLEARINGHOUSE');

Line: 59

    SELECT count(*)
    INTO  x_bank_count
    FROM ce_bank_accounts
    where bank_id = p_From_FK_id; --p_from_id;

Line: 124

  SELECT count(*)
  INTO  x_party_count
  FROM HZ_PARTY_USG_ASSIGNMENTS
  where  party_id =  p_From_FK_id  --p_from_id
  and PARTY_USAGE_CODE in ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH');

Line: 140

    SELECT count(*)
    INTO  x_branch_count
    FROM ce_bank_accounts
    where bank_branch_id = p_From_FK_id; --p_from_id;