APPS.AS_OSI_LEAD_PUB dependencies on AS_OSI_LOOKUP

Line 453: from as_osi_lookup

449: p_osi_lkp_tbl out OSI_LKP_TBL_TYPE
450: ) is
451: cursor lkp_cur (lkp_type_in in varchar2) is
452: select lkp_type, lkp_code, lkp_value
453: from as_osi_lookup
454: where (lkp_type = upper(lkp_type_in)
455: or lkp_type_in = 'ALL')
456: and nvl(enabled_flag,'Y') = 'Y'
457: order by 1,2;