APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_HOOK_PAYMENTS_T

Line 1488: from IBY_HOOK_PAYMENTS_T ipmt

1484: FROM ap_selected_invoice_checks apsic
1485: WHERE apsic.checkrun_name = P_Checkrun_Name;*/
1486: --RG
1487: SELECT ipmt.payment_id payment_id, ipmt.payment_date
1488: from IBY_HOOK_PAYMENTS_T ipmt
1489: where ipmt.call_app_pay_service_req_code = P_Checkrun_Name
1490: and ipmt.calling_app_id= 200;
1491:
1492: ------------------------------

Line 1563: FROM IBY_HOOK_PAYMENTS_T ipmt

1559:
1560: -- RG
1561: SELECT payment_date
1562: INTO l_awt_date
1563: FROM IBY_HOOK_PAYMENTS_T ipmt
1564: WHERE ipmt.call_app_pay_service_req_code = P_Checkrun_Name
1565: AND ipmt.calling_app_id=200;
1566: */
1567:

Line 4805: FROM iby_hook_payments_t ipmt

4801: */
4802: -- Update Payments
4803: CURSOR c_selected_invoice_checks (P_Selected_Check_Id IN Number) IS
4804: SELECT ipmt.payment_amount payment_amount
4805: FROM iby_hook_payments_t ipmt
4806: WHERE ipmt.payment_id = P_Selected_Check_id
4807: AND ipmt.calling_app_id = 200
4808: FOR UPDATE OF ipmt.payment_amount;
4809:

Line 5037: UPDATE iby_hook_payments_t ipmt

5033: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5034: -1 * l_total_wh_amount, apsic.currency_code)
5035: WHERE CURRENT OF c_selected_invoice_checks;
5036: */
5037: UPDATE iby_hook_payments_t ipmt
5038: SET ipmt.payment_amount = ap_utilities_pkg.ap_round_currency(
5039: NVL(l_prop_payment_amount, l_check_amount ) -
5040: l_total_wh_amount, ipmt.payment_currency_code)
5041: WHERE CURRENT OF c_selected_invoice_checks;

Line 5311: iby_hook_payments_t c

5307: select a.vendor_name, b.vendor_site_code
5308: into l_vendor_name,
5309: l_vendor_site_code
5310: from ap_suppliers a, ap_supplier_sites_all b,
5311: iby_hook_payments_t c
5312: where c.PAYEE_PARTY_ID = a.party_id
5313: and c.SUPPLIER_SITE_ID = b.vendor_site_id
5314: and a.vendor_id = b.vendor_id
5315: and c.payment_id = P_Selected_Check_id;

Line 5533: UPDATE iby_hook_payments_t ipmt

5529:
5530: CLOSE c_selected_invoices;
5531:
5532: -- RG Update also Payments Table with error
5533: UPDATE iby_hook_payments_t ipmt
5534: SET ipmt.dont_pay_flag = 'Y',
5535: ipmt.dont_pay_reason_code = AWT_ERROR
5536: WHERE ipmt.payment_id = P_Selected_Check_id;
5537: