DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 6757: from ap_payment_schedules_all

6753: where invoice_id = p_invoice_id;
6754:
6755: select count(*)
6756: into l_paid_schd_count
6757: from ap_payment_schedules_all
6758: where invoice_id = p_invoice_id
6759: and nvl(payment_status_flag,'N') <> 'N';
6760:
6761:

Line 6772: Update ap_payment_schedules_all

6768: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6769: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6770: END IF;
6771:
6772: Update ap_payment_schedules_all
6773: set due_date = due_date +(sysdate-l_old_terms_date)
6774: where invoice_id = p_invoice_id
6775: and nvl(payment_status_flag,'N') <> 'Y';
6776:

Line 8599: from ap_payment_schedules_all

8595: l_curr_calling_sequence := 'AP_APPROVAL_PKG.createPaymentSchedules <- '||P_calling_sequence;
8596:
8597: select count(*)
8598: into l_schedule_count
8599: from ap_payment_schedules_all
8600: where invoice_id = p_invoice_id;
8601:
8602: -------------------------------------------
8603: l_debug_info := 'createPaymentSchedules - payment schedule count = ' || l_schedule_count;