APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 51: FROM AR_RECEIVABLE_APPLICATIONS_ALL

47:
48: /* --sechawla 10282607 21-jan-2011
49: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
50: SELECT NVL(SUM(LINE_APPLIED), 0)
51: FROM AR_RECEIVABLE_APPLICATIONS_ALL
52: WHERE APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
53: AND APPLICATION_TYPE = 'CASH'
54: AND STATUS = 'APP';
55: */

Line 73: FROM ar_receivable_applications_all raa,

69: -- Modified cursor to query from ar_distributions_all to fetch receipt application
70: -- amounts where receipt has been applied either in OKL or in AR
71: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER,cp_customer_trx_line_id NUMBER) IS
72: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount
73: FROM ar_receivable_applications_all raa,
74: ar_distributions_all ad
75: WHERE raa.applied_customer_trx_id = cp_customer_trx_id
76: AND raa.application_type = 'CASH'
77: AND raa.status = 'APP'

Line 102: FROM AR_RECEIVABLE_APPLICATIONS_ALL

98: l_receipt_date DATE := sysdate;
99:
100: CURSOR l_receipt_date_csr(cp_customer_trx_id NUMBER) IS
101: SELECT MAX(apply_date)
102: FROM AR_RECEIVABLE_APPLICATIONS_ALL
103: WHERE APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
104: AND APPLICATION_TYPE = 'CASH'
105: AND STATUS = 'APP';
106: BEGIN

Line 127: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

123: --rkuttiya R12 B Billing Architecture modified the following cursor
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'

Line 142: from ar_receivable_applications_all raa,

138:
139: -- 13619067
140: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
141: select nvl(sum(line_applied),0)
142: from ar_receivable_applications_all raa,
143: okl_txd_ar_ln_dtls_b tld,
144: ra_customer_trx_lines_all ractrl
145: WHERE tld.ID = ractrl.interface_line_attribute14
146: and raa.applied_customer_trx_id=cp_customer_trx_id

Line 171: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

167:
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'

Line 828: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

824: SELECT RAA.receivable_application_id
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'