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: P_CODE_ACCOUNTING_DATE IN DATE Default NULL); -- Argentina AWT ER
133:
134:

Line 2160: jl_zz_ap_sup_awt_cd jlsc,

2156: ap_invoices apin,
2157: ap_invoice_distributions apid,
2158: ap_invoice_payments apip,
2159: jl_zz_ap_supp_awt_types jlst,
2160: jl_zz_ap_sup_awt_cd jlsc,
2161: jl_zz_ap_awt_types jlty
2162: WHERE
2163: apid.invoice_id = jlwh.invoice_id
2164: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2207: jl_zz_ap_sup_awt_cd jlsc,

2203: ap_invoices apin,
2204: ap_invoice_distributions apid,
2205: iby_hook_docs_in_pmt_t docs,
2206: jl_zz_ap_supp_awt_types jlst,
2207: jl_zz_ap_sup_awt_cd jlsc,
2208: jl_zz_ap_awt_types jlty
2209: WHERE docs.payment_id = P_Check_Id
2210: AND apid.invoice_id = jlwh.invoice_id
2211: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2269: jl_zz_ap_sup_awt_cd jlsc,

2265: ap_selected_invoices apsi,
2266: -- Payment Exchange Rate ER 8648739 End 3
2267: iby_hook_docs_in_pmt_t docs,
2268: jl_zz_ap_supp_awt_types jlst,
2269: jl_zz_ap_sup_awt_cd jlsc,
2270: jl_zz_ap_awt_types jlty
2271: WHERE docs.payment_id = P_Selected_Check_Id
2272: AND apid.invoice_id = jlwh.invoice_id
2273: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256

Line 2309: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;

2305: rec_payment_wh Rec_Payment_Withholding;
2306: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;
2307: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;
2308: rec_suppl_awt_type jl_zz_ap_supp_awt_types%ROWTYPE;
2309: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;
2310:
2311: ------------------------
2312: -- Tables Declaration
2313: ------------------------

Line 3067: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,

3063: P_Calling_Sequence IN Varchar2,
3064: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
3065: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
3066: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
3067: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
3068: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
3069: P_CODE_ACCOUNTING_DATE IN DATE Default NULL) -- Argentina AWT ER
3070: IS
3071: