DBA Data[Home] [Help]

APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 1353: FROM ap_payment_schedules_all

1349: BEGIN
1350:
1351: SELECT COUNT(*)
1352: INTO holds_count
1353: FROM ap_payment_schedules_all
1354: WHERE hold_flag = 'Y'
1355: AND invoice_id = l_invoice_id;
1356:
1357: RETURN (holds_count);

Line 1901: FROM AP_PAYMENT_SCHEDULES_ALL

1897: FROM AP_SELECTED_INVOICES
1898: WHERE invoice_id = P_invoice_id
1899: UNION
1900: SELECT 'Y'
1901: FROM AP_PAYMENT_SCHEDULES_ALL
1902: WHERE invoice_id = P_invoice_id
1903: AND checkrun_id IS NOT NULL;
1904:
1905: BEGIN