DBA Data[Home] [Help]

APPS.AP_EXTENDED_WITHHOLDING_PKG dependencies on JL_ZZ_AP_INV_DIS_WH

Line 452: -- Select 'EXIST' from jl_zz_ap_inv_dis_wh

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

Line 457: ,jl_zz_ap_inv_dis_wh jid

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