APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_HOOK_PAYMENTS_T

Line 1554: from IBY_HOOK_PAYMENTS_T ipmt

1550: FROM ap_selected_invoice_checks apsic
1551: WHERE apsic.checkrun_name = P_Checkrun_Name;*/
1552: --RG
1553: SELECT ipmt.payment_id payment_id, ipmt.payment_date
1554: from IBY_HOOK_PAYMENTS_T ipmt
1555: where ipmt.call_app_pay_service_req_code = P_Checkrun_Name
1556: and ipmt.calling_app_id= 200;
1557:
1558: ------------------------------

Line 1630: FROM IBY_HOOK_PAYMENTS_T ipmt

1626:
1627: -- RG
1628: SELECT payment_date
1629: INTO l_awt_date
1630: FROM IBY_HOOK_PAYMENTS_T ipmt
1631: WHERE ipmt.call_app_pay_service_req_code = P_Checkrun_Name
1632: AND ipmt.calling_app_id=200;
1633: */
1634:

Line 5045: FROM iby_hook_payments_t ipmt

5041: */
5042: -- Update Payments
5043: CURSOR c_selected_invoice_checks (P_Selected_Check_Id IN Number) IS
5044: SELECT ipmt.payment_amount payment_amount
5045: FROM iby_hook_payments_t ipmt
5046: WHERE ipmt.payment_id = P_Selected_Check_id
5047: AND ipmt.calling_app_id = 200
5048: FOR UPDATE OF ipmt.payment_amount;
5049:

Line 5283: UPDATE iby_hook_payments_t ipmt

5279: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5280: -1 * l_total_wh_amount, apsic.currency_code)
5281: WHERE CURRENT OF c_selected_invoice_checks;
5282: */
5283: UPDATE iby_hook_payments_t ipmt
5284: SET ipmt.payment_amount = ap_utilities_pkg.ap_round_currency(
5285: NVL(l_prop_payment_amount, l_check_amount ) -
5286: l_total_wh_amount, ipmt.payment_currency_code)
5287: WHERE CURRENT OF c_selected_invoice_checks;

Line 5602: iby_hook_payments_t c

5598: select a.vendor_name, b.vendor_site_code
5599: into l_vendor_name,
5600: l_vendor_site_code
5601: from ap_suppliers a, ap_supplier_sites_all b,
5602: iby_hook_payments_t c
5603: where c.PAYEE_PARTY_ID = a.party_id
5604: and c.SUPPLIER_SITE_ID = b.vendor_site_id
5605: and a.vendor_id = b.vendor_id
5606: and c.payment_id = P_Selected_Check_id;

Line 5845: UPDATE iby_hook_payments_t ipmt

5841:
5842: CLOSE c_selected_invoices;
5843:
5844: -- RG Update also Payments Table with error
5845: UPDATE iby_hook_payments_t ipmt
5846: SET ipmt.dont_pay_flag = 'Y',
5847: ipmt.dont_pay_reason_code = AWT_ERROR
5848: WHERE ipmt.payment_id = P_Selected_Check_id;
5849: