DBA Data[Home] [Help]

APPS.IBY_FNDCPT_COMMON_PUB dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 131: p_payer_org_type IN iby_external_payers_all.org_type%TYPE,

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,

Line 132: p_payer_org_id IN iby_external_payers_all.org_id%TYPE,

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,

Line 133: p_payer_cust_acct_id IN iby_external_payers_all.cust_account_id%TYPE,

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,

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

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

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

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

Line 140: p_compare_acct_site_id IN iby_external_payers_all.acct_site_use_id%TYPE

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