448: ,P_Global_Attribute3 ap_invoice_distributions.global_attribute3%TYPE
449: ) return Varchar2
450: IS
451: -------------------------------------------------------------------------
452: -- Select 'EXIST' from jl_zz_ap_inv_dis_wh
453: -------------------------------------------------------------------------
454: CURSOR Invoice_Dis_Withholdings IS
455: SELECT 'EXIST' Awt
456: FROM ap_invoice_distributions apid
453: -------------------------------------------------------------------------
454: CURSOR Invoice_Dis_Withholdings IS
455: SELECT 'EXIST' Awt
456: FROM ap_invoice_distributions apid
457: ,jl_zz_ap_inv_dis_wh jid
458: ,jl_zz_ap_sup_awt_cd jsw
459: ,ap_tax_codes apc
460: WHERE apid.invoice_distribution_id = P_Invoice_Distribution_Id
461: AND apid.invoice_id = jid.invoice_id