APPS.JA_JAINSTR_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 45: AR_RECEIVABLE_APPLICATIONS_ALL

41: CURSOR FETCH_RECEIPT_AMOUNT IS
42: SELECT
43: SUM(AMOUNT_APPLIED)
44: FROM
45: AR_RECEIVABLE_APPLICATIONS_ALL
46: WHERE APPLIED_CUSTOMER_TRX_ID = INVOICE_ID
47: AND APPLICATION_TYPE = 'CASH'
48: AND STATUS in ( 'APP' , 'UNAPP' );
49: LN_RECEIPT_AMOUNT AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE;

Line 49: LN_RECEIPT_AMOUNT AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE;

45: AR_RECEIVABLE_APPLICATIONS_ALL
46: WHERE APPLIED_CUSTOMER_TRX_ID = INVOICE_ID
47: AND APPLICATION_TYPE = 'CASH'
48: AND STATUS in ( 'APP' , 'UNAPP' );
49: LN_RECEIPT_AMOUNT AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE;
50: BEGIN
51: OPEN FETCH_RECEIPT_AMOUNT;
52: FETCH FETCH_RECEIPT_AMOUNT
53: INTO LN_RECEIPT_AMOUNT;