APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JL_ZZ_AP_COMP_AWT_TYPES

Line 290: FROM jl_zz_ap_comp_awt_types

286: /* bug 16010780
287: Cursor Company_Awt_Types (PC_Legal_Entity_ID xle_entity_profiles.legal_entity_id%TYPE)
288: IS
289: SELECT awt_type_code
290: FROM jl_zz_ap_comp_awt_types
291: WHERE legal_entity_id = PC_Legal_Entity_ID
292: --location_id = PC_Location_ID
293: AND wh_agent_flag = 'Y';
294:

Line 350: from jl_zz_ap_comp_awt_types

346: select decode((select 'TRUE'
347: from ap_invoices AP
348: where AP.invoice_id = P_Invoice_ID
349: and EXISTS (select /*+ NO_UNNEST */ 'x'
350: from jl_zz_ap_comp_awt_types
351: where legal_entity_id = AP.legal_entity_id
352: and wh_agent_flag = 'Y'
353: and awt_type_code = P_Awt_Type_Code)
354: and ROWNUM=1), 'TRUE', 'TRUE','FALSE')