APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 921: FROM IBY_Hook_Docs_in_PMT_T ihd

917: P_Payment_Num IN Number,
918: P_Checkrun_Name IN Varchar2)
919: IS
920: SELECT Ihd.Payment_id selected_check_id
921: FROM IBY_Hook_Docs_in_PMT_T ihd
922: WHERE ihd.calling_app_doc_unique_ref2 = P_Invoice_Id
923: AND ihd.calling_app_doc_unique_ref3 = P_Payment_Num
924: AND ihd.calling_App_doc_unique_ref1 = P_Checkrun_ID
925: AND ihd.calling_app_id = 200 ;

Line 2205: iby_hook_docs_in_pmt_t docs,

2201: FROM
2202: jl_zz_ap_inv_dis_wh jlwh,
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

Line 2267: iby_hook_docs_in_pmt_t docs,

2263: ap_invoice_distributions apid,
2264: -- Payment Exchange Rate ER 8648739 Start 3
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

Line 3460: iby_hook_docs_in_pmt_t docs

3456: docs.calling_app_doc_unique_ref3 payment_num
3457: FROM ap_invoices apin,
3458: ap_invoice_distributions apid,
3459: ap_selected_invoices apsi,
3460: iby_hook_docs_in_pmt_t docs
3461: WHERE apin.invoice_id = apid.invoice_id
3462: AND apin.invoice_id = apsi.invoice_id
3463: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
3464: and docs.payment_id = P_Check_Id

Line 3494: iby_hook_docs_in_pmt_t docs

3490: docs.calling_app_doc_unique_ref3 payment_num
3491: FROM ap_invoices apin,
3492: ap_invoice_distributions apid,
3493: ap_selected_invoices apsi,
3494: iby_hook_docs_in_pmt_t docs
3495: WHERE apin.invoice_id = apid.invoice_id
3496: AND apin.invoice_id = apsi.invoice_id
3497: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
3498: and docs.payment_id = P_Selected_Check_Id

Line 5025: FROM iby_hook_docs_in_pmt_t docs,

5021: -- nvl(apsi.invoice_exchange_rate, 1) invoice_exchange_rate,
5022: nvl(apsi.payment_exchange_rate, 1) payment_exchange_rate,
5023: -- Payment Exchange Rate ER 8648739 End 9
5024: nvl(apsi.payment_cross_rate, 1) payment_cross_rate
5025: FROM iby_hook_docs_in_pmt_t docs,
5026: ap_selected_invoices apsi
5027: WHERE docs.payment_id = P_Selected_Check_id
5028: AND docs.calling_app_id = 200
5029: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2

Line 5092: FROM iby_hook_docs_in_pmt_t docs,

5088: -- Bug Number: 1480825 -- Just update the invoices in the same payment check.
5089: -----------------------------------------------------------------------------
5090: SELECT count(*)
5091: INTO l_count_inv
5092: FROM iby_hook_docs_in_pmt_t docs,
5093: -- RG ap_selected_invoices apsi,
5094: ap_awt_temp_distributions awtd
5095: WHERE docs.payment_id = P_Selected_Check_Id
5096: AND nvl(docs.dont_pay_flag,'N') ='N'

Line 5122: FROM iby_hook_docs_in_pmt_t docs

5118: -- This would however be redundant when we Rebuild the batch.
5119:
5120: SELECT SUM(docs.document_amount)
5121: INTO l_prop_payment_amount
5122: FROM iby_hook_docs_in_pmt_t docs
5123: -- ap_selected_invoices apsi
5124: WHERE docs.payment_id = P_Selected_Check_Id
5125: AND nvl(docs.dont_pay_flag,'N') ='N'
5126: AND docs.calling_app_id =200;

Line 5179: FROM IBY_HOOK_DOCS_IN_PMT_T

5175: */
5176:
5177: SELECT document_currency_code
5178: INTO l_payment_currency_code
5179: FROM IBY_HOOK_DOCS_IN_PMT_T
5180: WHERE payment_id = P_Selected_Check_Id
5181: AND document_payable_id = rec_sel_inv.document_payable_id;
5182: -----------------------------------------------------
5183: -- Calculates the withholding amount for the invoice

Line 5243: UPDATE iby_hook_docs_in_pmt_t docs

5239: WHERE invoice_id = rec_sel_inv.invoice_id
5240: AND payment_num = rec_sel_inv.payment_num; --bug 12921144
5241: -- WHERE CURRENT OF c_selected_invoices;
5242:
5243: UPDATE iby_hook_docs_in_pmt_t docs
5244: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
5245: docs.document_amount - l_withholding_amount,
5246: l_payment_currency_code),
5247: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(

Line 5570: FROM iby_hook_docs_in_pmt_t docs,

5566: SELECT nvl(sum(docs.document_amount/
5567: nvl(apsi.payment_cross_rate, 1) *
5568: nvl(apsi.invoice_exchange_rate, 1)), 0)
5569: INTO l_payment_amount
5570: FROM iby_hook_docs_in_pmt_t docs,
5571: ap_selected_invoices apsi
5572: WHERE docs.payment_id = P_Selected_Check_id
5573: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2
5574: AND docs.dont_pay_flag = 'N'

Line 5591: FROM IBY_HOOK_DOCS_IN_PMT_T docs,

5587: SELECT asi.vendor_name,
5588: asi.vendor_site_code
5589: INTO l_vendor_name,
5590: l_vendor_site_code
5591: FROM IBY_HOOK_DOCS_IN_PMT_T docs,
5592: ap_selected_invoices_all asi
5593: WHERE docs.payment_id = P_Selected_Check_id
5594: AND docs.calling_app_doc_unique_ref2 = asi.invoice_id
5595: AND docs.calling_app_id=200;

Line 5792: FROM iby_hook_docs_in_pmt_t docs

5788: docs.calling_app_doc_unique_ref2 invoice_id
5789: -- apsi.ok_to_pay_flag ok_to_pay_flag,
5790: -- apsi.dont_pay_reason_code dont_pay_reason_code,
5791: -- apsi.dont_pay_description dont_pay_description
5792: FROM iby_hook_docs_in_pmt_t docs
5793: -- ap_selected_invoices apsi
5794: WHERE docs.payment_id = P_Selected_Check_id
5795: AND docs.dont_pay_flag = 'N'
5796: AND docs.calling_app_id = 200

Line 5830: UPDATE iby_hook_docs_in_pmt_t docs

5826: l_dont_pay_reason_code,
5827: l_invoice_id;
5828:
5829: EXIT WHEN c_selected_invoices%NOTFOUND;
5830: UPDATE iby_hook_docs_in_pmt_t docs
5831: SET docs.dont_pay_flag = 'Y',
5832: docs.dont_pay_reason_code = AWT_ERROR
5833: WHERE CURRENT OF c_selected_invoices;
5834: