APPS.IBY_AVS_CODE_PKG dependencies on IBY_MAPPINGS

Line 22: from iby_mappings

18: -- then value would be always null
19: cursor c_get_factor_config(ci_payeeid varchar2, ci_avs_code varchar2)
20: is
21: select value
22: from iby_mappings
23: where ( ( payeeid is null and ci_payeeid is null ) or
24: payeeid = ci_payeeid)
25: and mapping_type = 'AVS_CODE_TYPE'
26: and INSTR(mapping_code, ci_avs_code, 1)>0;

Line 37: from iby_mappings

33: ** if not the set payeeid to null.
34: */
35:
36: select count(1) into l_cnt
37: from iby_mappings
38: where mapping_type = 'AVS_CODE_TYPE'
39: and payeeid = i_payeeid;
40:
41: if ( l_cnt = 0 ) then