APPS.FV_CCR_GRP SQL Statements

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

Line: 41

		SELECT 	ccr_id
		INTO   	x_ccr_id
		FROM   	fv_ccr_vendors
		WHERE 	nvl(vendor_id,-99) = p_object_id
		AND 	plus_four IS NULL;

Line: 47

		SELECT 	ccr_id
		INTO   	x_ccr_id
		FROM   	fv_ccr_vendors
		WHERE 	nvl(bank_branch_id,-99) = p_object_id;

Line: 52

		SELECT 	ccr_id
		INTO   	x_ccr_id
		FROM   	fv_ccr_orgs fcorg
		WHERE	(nvl(fcorg.pay_site_id,-99)=p_object_id
			OR nvl(fcorg.main_address_site_id,-99)=p_object_id);

Line: 58

		SELECT 	ccr_id
		INTO   	x_ccr_id
		FROM   	fv_ccr_orgs fcorg
		WHERE	nvl(bank_account_id,-99) = p_object_id;

Line: 163

	SELECT	fcv.ccr_status
	INTO	x_ccr_status
	FROM 	fv_ccr_vendors fcv, fv_ccr_orgs fco
	WHERE 	fcv.CCR_ID = fco.CCR_ID
	AND	(nvl(fco.pay_site_id,-99)=p_vendor_site_id
			OR nvl(fco.main_address_site_id,-99)=p_vendor_site_id);

Line: 266

  SELECT vendor_type_lookup_code
    INTO l_vendor_type
    FROM po_vendors
   WHERE vendor_id = p_vendor_id;

Line: 366

	SELECT bank_account_id
	INTO l_bank_account_id
	FROM fv_ccr_orgs
	WHERE pay_site_id = p_vendor_site_id;

Line: 437

  FUNCTION SELECT_THIRD_PARTY
  (
    p_vendor_site_id NUMBER
  ) RETURN VARCHAR2
  IS
    l_api_version number := 1.0;

Line: 472

  FUNCTION  SELECT_BANK_ACCOUNT
  (
    p_bank_account_id IN NUMBER,
    p_vendor_site_id NUMBER
  ) RETURN NUMBER
  IS
    l_api_version number := 1.0;

Line: 500

        SELECT bank_account_id
          INTO l_bank_account_id
          FROM fv_ccr_orgs fco
         WHERE fco.pay_site_id = p_vendor_site_id;