APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on JA_LOOKUPS

Line 57: FROM ja_lookups

53: -- Added by ChongLei for DTC Bug#13768894, begin on 20120222
54: -------------------------------------------------------------------------------
55: CURSOR c_get_section_type(c_section_code VARCHAR2) IS
56: SELECT LTRIM(UPPER(lookup_type),'JAI_') section_type
57: FROM ja_lookups
58: WHERE lookup_code = c_section_code
59: AND lookup_type IN(
60: SELECT DISTINCT 'JAI_' || b.lookup_code
61: FROM ja_lookups b

Line 61: FROM ja_lookups b

57: FROM ja_lookups
58: WHERE lookup_code = c_section_code
59: AND lookup_type IN(
60: SELECT DISTINCT 'JAI_' || b.lookup_code
61: FROM ja_lookups b
62: WHERE b.lookup_type = 'JAI_AP_TDS_SECTION_TYPES'
63: );
64: lv_section_type varchar2(30);
65: -------------------------------------------------------------------------------