APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 128: ,OKL_BPD_TLD_AR_LINES_V ARL

124: /* 13619067
125: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
126: SELECT NVL(SUM(LINE_APPLIED), 0)
127: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
128: ,OKL_BPD_TLD_AR_LINES_V ARL
129: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
130: AND RAA.APPLICATION_TYPE = 'CASH'
131: AND RAA.STATUS = 'APP'
132: AND RAA.applied_customer_trx_id = arl.customer_trx_id

Line 172: ,OKL_BPD_TLD_AR_LINES_V ARL

168: --rkuttiya R12 B Billing modified following cursor
169: CURSOR l_receipt_date_csr(cp_customer_trx_id NUMBER) IS
170: SELECT MAX(raa.apply_date)
171: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
172: ,OKL_BPD_TLD_AR_LINES_V ARL
173: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
174: AND RAA.APPLICATION_TYPE = 'CASH'
175: AND RAA.STATUS = 'APP'
176: AND RAA.applied_customer_trx_id = arl.customer_trx_id

Line 829: ,OKL_BPD_TLD_AR_LINES_V ARL

825: ,RAA.LINE_APPLIED
826: ,RAA.apply_date
827: ,ARL.tld_id tld_id
828: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
829: ,OKL_BPD_TLD_AR_LINES_V ARL
830: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
831: AND RAA.APPLICATION_TYPE = 'CASH'
832: AND RAA.STATUS = 'APP'
833: AND RAA.applied_customer_trx_id = arl.customer_trx_id