DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on DUAL

Line 2411: individual invoice line and individual processing fee within the invoice.

2407: So how does the system to determine which rule need to be picked for processing fee process?
2408:
2409: Question 2:
2410: There is no relationship between lines within the same invoice. Hence this is no way to find out the link between
2411: individual invoice line and individual processing fee within the invoice.
2412:
2413: Question 3:
2414: Processing fee:
2415: if system subtract the fee amount from invoice amount, we may lose the track of the original transaaction amount

Line 2637: FROM dual;

2633: -- Fetch Ap Interface Sequence Number
2634: -----------------------------------------------------------------
2635: CURSOR seq_csr IS
2636: SELECT ap_invoices_interface_s.nextval
2637: FROM dual;
2638:
2639: ------------------------------------------------------------
2640: -- Declare records: Payable Invoice Headers and Lines
2641: ------------------------------------------------------------

Line 3195: FROM dual;

3191: -- Fetch Ap Interface Sequence Number
3192: -----------------------------------------------------------------
3193: CURSOR seq_csr IS
3194: SELECT ap_invoices_interface_s.nextval
3195: FROM dual;
3196:
3197: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
3198:
3199: ------------------------------------------------------------

Line 4227: FROM dual;

4223: -- Fetch Ap Interface Sequence Number
4224: -----------------------------------------------------------------
4225: CURSOR seq_csr IS
4226: SELECT ap_invoices_interface_s.nextval
4227: FROM dual;
4228:
4229: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
4230:
4231: ------------------------------------------------------------