DBA Data[Home] [Help]

APPS.IBY_FNDCPT_COMMON_PUB dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 134: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,

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,

Line 135: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,

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,

Line 136: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,

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,

Line 137: p_payer_acct_site_id IN iby_external_payers_all.acct_site_use_id%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,

Line 140: p_compare_org_type IN iby_external_payers_all.org_type%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: )

Line 141: p_compare_org_id IN iby_external_payers_all.org_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: )
145: RETURN VARCHAR2;

Line 142: p_compare_cust_acct_id IN iby_external_payers_all.cust_account_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;
146:

Line 143: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE

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: --