DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 49: FROM AR_RECEIVABLE_APPLICATIONS_ALL

45: l_receipt_amount NUMBER := 0;
46:
47: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
48: SELECT NVL(SUM(LINE_APPLIED), 0)
49: FROM AR_RECEIVABLE_APPLICATIONS_ALL
50: WHERE APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
51: AND APPLICATION_TYPE = 'CASH'
52: AND STATUS = 'APP';
53: BEGIN

Line 72: FROM AR_RECEIVABLE_APPLICATIONS_ALL

68: l_receipt_date DATE := sysdate;
69:
70: CURSOR l_receipt_date_csr(cp_customer_trx_id NUMBER) IS
71: SELECT MAX(apply_date)
72: FROM AR_RECEIVABLE_APPLICATIONS_ALL
73: WHERE APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
74: AND APPLICATION_TYPE = 'CASH'
75: AND STATUS = 'APP';
76: BEGIN

Line 96: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

92:
93: --rkuttiya R12 B Billing Architecture modified the following cursor
94: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
95: SELECT NVL(SUM(LINE_APPLIED), 0)
96: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
97: ,OKL_BPD_TLD_AR_LINES_V ARL
98: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
99: AND RAA.APPLICATION_TYPE = 'CASH'
100: AND RAA.STATUS = 'APP'

Line 126: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

122:
123: --rkuttiya R12 B Billing modified following cursor
124: CURSOR l_receipt_date_csr(cp_customer_trx_id NUMBER) IS
125: SELECT MAX(raa.apply_date)
126: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
127: ,OKL_BPD_TLD_AR_LINES_V ARL
128: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
129: AND RAA.APPLICATION_TYPE = 'CASH'
130: AND RAA.STATUS = 'APP'

Line 783: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA

779: SELECT RAA.receivable_application_id
780: ,RAA.LINE_APPLIED
781: ,RAA.apply_date
782: ,ARL.tld_id tld_id
783: FROM AR_RECEIVABLE_APPLICATIONS_ALL RAA
784: ,OKL_BPD_TLD_AR_LINES_V ARL
785: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
786: AND RAA.APPLICATION_TYPE = 'CASH'
787: AND RAA.STATUS = 'APP'