Annotation: transactions.is_valid_party_by_stock_master_id

CREATE OR REPLACE FUNCTION transactions.is_valid_party_by_stock_master_id(_stock_master_id bigint, _party_id bigint)
RETURNS boolean

Information: transactions.is_valid_party_by_stock_master_id

Schema	transactions
Function Name	is_valid_party_by_stock_master_id
Arguments	_stock_master_id bigint, _party_id bigint
Owner	postgres
Result Type	boolean
Description

Implementation: transactions.is_valid_party_by_stock_master_id

CREATE OR REPLACE FUNCTION transactions.is_valid_party_by_stock_master_id(_stock_master_id bigint, _party_id bigint)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS(SELECT * FROM transactions.stock_master WHERE stock_master_id=$1 AND party_id=$2) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$