APPS.JA_JAINSTCR_XMLP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 32: CURSOR C_INV_AMOUNT(CP_ACCT_CLASS IN RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE) IS

28: RETURN (TRUE);
29: END AFTERPFORM;
30:
31: FUNCTION CF_INVOICE_AMOUNTFORMULA(INVOICE_ID1 IN NUMBER) RETURN NUMBER IS
32: CURSOR C_INV_AMOUNT(CP_ACCT_CLASS IN RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE) IS
33: SELECT
34: AMOUNT
35: FROM
36: RA_CUST_TRX_LINE_GL_DIST_ALL

Line 36: RA_CUST_TRX_LINE_GL_DIST_ALL

32: CURSOR C_INV_AMOUNT(CP_ACCT_CLASS IN RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE) IS
33: SELECT
34: AMOUNT
35: FROM
36: RA_CUST_TRX_LINE_GL_DIST_ALL
37: WHERE CUSTOMER_TRX_ID = INVOICE_ID1
38: AND ACCOUNT_CLASS = CP_ACCT_CLASS - 'REC'
39: AND LATEST_REC_FLAG = 'Y';
40: V_INVOICE_AMOUNT NUMBER;