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