DBA Data[Home] [Help]

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_SUP_AWT_CD

Line 130: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,

126: P_Calling_Sequence IN Varchar2,
127: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
128: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
129: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
130: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
131: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding);
132:
133:
134:

Line 2081: jl_zz_ap_sup_awt_cd jlsc,

2077: ap_invoices apin,
2078: ap_invoice_distributions apid,
2079: ap_invoice_payments apip,
2080: jl_zz_ap_supp_awt_types jlst,
2081: jl_zz_ap_sup_awt_cd jlsc,
2082: jl_zz_ap_awt_types jlty
2083: WHERE
2084: apid.invoice_id = jlwh.invoice_id
2085: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2125: jl_zz_ap_sup_awt_cd jlsc,

2121: ap_invoices apin,
2122: ap_invoice_distributions apid,
2123: iby_hook_docs_in_pmt_t docs,
2124: jl_zz_ap_supp_awt_types jlst,
2125: jl_zz_ap_sup_awt_cd jlsc,
2126: jl_zz_ap_awt_types jlty
2127: WHERE docs.payment_id = P_Check_Id
2128: AND apid.invoice_id = jlwh.invoice_id
2129: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2183: jl_zz_ap_sup_awt_cd jlsc,

2179: ap_invoice_distributions apid,
2180: -- ap_selected_invoices apsi,
2181: iby_hook_docs_in_pmt_t docs,
2182: jl_zz_ap_supp_awt_types jlst,
2183: jl_zz_ap_sup_awt_cd jlsc,
2184: jl_zz_ap_awt_types jlty
2185: WHERE docs.payment_id = P_Selected_Check_Id
2186: AND apid.invoice_id = jlwh.invoice_id
2187: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2218: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;

2214: rec_payment_wh Rec_Payment_Withholding;
2215: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;
2216: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;
2217: rec_suppl_awt_type jl_zz_ap_supp_awt_types%ROWTYPE;
2218: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;
2219:
2220: ------------------------
2221: -- Tables Declaration
2222: ------------------------

Line 2924: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,

2920: P_Calling_Sequence IN Varchar2,
2921: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
2922: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
2923: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
2924: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
2925: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)
2926: IS
2927:
2928: l_debug_info Varchar2(300);