APPS.AP_BANK_CHARGE_PKG dependencies on IBY_HOOK_PAYMENTS_T

Line 1326: FROM iby_hook_payments_t iby,

1322:
1323: IF p_supplier_site_id IS NOT NULL THEN
1324: SELECT PVS.bank_charge_bearer
1325: INTO p_bank_charge_bearer
1326: FROM iby_hook_payments_t iby,
1327: ap_supplier_sites_all PVS
1328: WHERE iby.payment_id = p_selected_check_id
1329: AND iby.supplier_site_id = PVS.vendor_site_id;
1330: END IF;

Line 1377: FROM iby_hook_payments_t

1373: END IF;
1374:
1375: SELECT count(*)
1376: INTO p_num_of_invoices
1377: FROM iby_hook_payments_t
1378: WHERE payment_id = p_selected_check_id;
1379:
1380: l_debug_info := 'Get min_account_unit and precision for currency';
1381: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1466: FROM iby_hook_payments_t iby,

1462: iby.external_bank_account_id,
1463: iby.dont_pay_flag,
1464: iby.internal_bank_account_id,
1465: iby.supplier_site_id
1466: FROM iby_hook_payments_t iby,
1467: ap_system_parameters_all asp --5007989
1468: WHERE dont_pay_flag <> 'Y'
1469: AND nvl(dont_pay_reason_code,'dummy') <> 'OVERFLOW'
1470: AND asp.org_id = iby.org_id

Line 1723: l_debug_info := 'Update iby_hook_payments_t if ok_to_pay_flag is N';

1719: -- Step 4.3
1720: -- Update ap_selected_invoice_checks
1721: -------------------------------------------------
1722: if (NVL(l_bc_ok_to_pay_flag,'Y') = 'N') then
1723: l_debug_info := 'Update iby_hook_payments_t if ok_to_pay_flag is N';
1724: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1725: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1726: END IF;
1727:

Line 1728: UPDATE iby_hook_payments_t

1724: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1725: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1726: END IF;
1727:
1728: UPDATE iby_hook_payments_t
1729: SET payment_amount = 0,
1730: dont_pay_flag = 'Y',
1731: dont_pay_reason_code = l_bc_dont_pay_reason_code
1732: WHERE payment_id = l_selected_check_id;

Line 1851: l_debug_info := 'Update iby_hook_payments_t';

1847: -- Step 7 , Update ap_selected_invoice_checks
1848: -- 1, Update discount_amount to the bank_charge_amount and
1849: -- 2, subtract the bank charge amount from the check amount
1850: ----------------------------------------------------------
1851: l_debug_info := 'Update iby_hook_payments_t';
1852: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1853: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1854: END IF;
1855:

Line 1856: UPDATE iby_hook_payments_t

1852: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1853: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1854: END IF;
1855:
1856: UPDATE iby_hook_payments_t
1857: SET DISCOUNT_AMOUNT_TAKEN= l_best_bank_charge,
1858: payment_amount = l_amt_due - l_best_bank_charge
1859: WHERE payment_id = l_selected_check_id;
1860:

Line 1918: FROM iby_hook_payments_t

1914:
1915:
1916: SELECT l_amt_due - l_best_bank_charge - SUM(payment_amount)
1917: INTO l_rounding_error
1918: FROM iby_hook_payments_t
1919: WHERE payment_id = l_selected_check_id;
1920:
1921:
1922: ---------------------------------------------------------