APPS.AP_BANK_CHARGE_PKG dependencies on IBY_HOOK_PAYMENTS_T

Line 1424: FROM iby_hook_payments_t iby,

1420: -- Bug7014739. Added nvl.
1421: IF p_supplier_site_id IS NOT NULL THEN
1422: SELECT nvl(PVS.bank_charge_bearer, 'I')
1423: INTO p_bank_charge_bearer
1424: FROM iby_hook_payments_t iby,
1425: ap_supplier_sites_all PVS
1426: WHERE iby.payment_id = p_selected_check_id
1427: AND iby.supplier_site_id = PVS.vendor_site_id;
1428: END IF;

Line 1486: FROM iby_hook_payments_t

1482: END IF;
1483:
1484: SELECT count(*)
1485: INTO p_num_of_invoices
1486: FROM iby_hook_payments_t
1487: WHERE payment_id = p_selected_check_id;
1488:
1489: l_debug_info := 'Get min_account_unit and precision for currency';
1490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1575: FROM iby_hook_payments_t iby,

1571: iby.external_bank_account_id,
1572: iby.dont_pay_flag,
1573: iby.internal_bank_account_id,
1574: iby.supplier_site_id
1575: FROM iby_hook_payments_t iby,
1576: ap_system_parameters_all asp --5007989
1577: WHERE dont_pay_flag <> 'Y'
1578: AND nvl(dont_pay_reason_code,'dummy') <> 'OVERFLOW'
1579: AND asp.org_id = iby.org_id

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

1834: -- Step 4.3
1835: -- Update ap_selected_invoice_checks
1836: -------------------------------------------------
1837: if (NVL(l_bc_ok_to_pay_flag,'Y') = 'N') then
1838: l_debug_info := 'Update iby_hook_payments_t if ok_to_pay_flag is N';
1839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1841: END IF;
1842:

Line 1843: UPDATE iby_hook_payments_t

1839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1841: END IF;
1842:
1843: UPDATE iby_hook_payments_t
1844: SET payment_amount = 0,
1845: dont_pay_flag = 'Y',
1846: dont_pay_reason_code = l_bc_dont_pay_reason_code
1847: WHERE payment_id = l_selected_check_id;

Line 1966: l_debug_info := 'Update iby_hook_payments_t';

1962: -- Step 7 , Update ap_selected_invoice_checks
1963: -- 1, Update discount_amount to the bank_charge_amount and
1964: -- 2, subtract the bank charge amount from the check amount
1965: ----------------------------------------------------------
1966: l_debug_info := 'Update iby_hook_payments_t';
1967: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1969: END IF;
1970:

Line 1971: UPDATE iby_hook_payments_t

1967: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1969: END IF;
1970:
1971: UPDATE iby_hook_payments_t
1972: SET DISCOUNT_AMOUNT_TAKEN= l_best_bank_charge,
1973: payment_amount = l_amt_due - l_best_bank_charge
1974: WHERE payment_id = l_selected_check_id;
1975: