127: -- query to limit the result set (and calls to this function)
128: --
129: FUNCTION Compare_Payer
130: (
131: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,
132: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,
133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
128: --
129: FUNCTION Compare_Payer
130: (
131: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,
132: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,
133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
129: FUNCTION Compare_Payer
130: (
131: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,
132: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,
133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
130: (
131: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,
132: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,
133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
138: p_compare_org_id IN iby_external_payers_all.org_id%TYPE,
133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
138: p_compare_org_id IN iby_external_payers_all.org_id%TYPE,
139: p_compare_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
140: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE
141: )
134: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE,
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
138: p_compare_org_id IN iby_external_payers_all.org_id%TYPE,
139: p_compare_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
140: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE
141: )
142: RETURN VARCHAR2;
135: p_payer_level IN VARCHAR2,
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
138: p_compare_org_id IN iby_external_payers_all.org_id%TYPE,
139: p_compare_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
140: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE
141: )
142: RETURN VARCHAR2;
143:
136: p_equiv_type IN VARCHAR2,
137: p_compare_org_type IN iby_external_payers_all.org_type%TYPE,
138: p_compare_org_id IN iby_external_payers_all.org_id%TYPE,
139: p_compare_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,
140: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE
141: )
142: RETURN VARCHAR2;
143:
144: --