APPS.IBY_AVS_CODE_PKG dependencies on IBY_MAPPINGS

Line 17: from iby_mappings

13:
14: cursor c_get_factor_config(ci_payeeid varchar2, ci_avs_code varchar2)
15: is
16: select value
17: from iby_mappings
18: where ( ( payeeid is null and ci_payeeid is null ) or
19: payeeid = ci_payeeid)
20: and mapping_type = 'AVS_CODE_TYPE'
21: and mapping_code = ci_avs_code;

Line 32: from iby_mappings

28: ** if not the set payeeid to null.
29: */
30:
31: select count(1) into l_cnt
32: from iby_mappings
33: where mapping_type = 'AVS_CODE_TYPE'
34: and payeeid = i_payeeid;
35:
36: if ( l_cnt = 0 ) then