APPS.JA_JAINTSLS_XMLP_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 69: RA_CUSTOMER_TRX_LINES_ALL CUTXL,

65: INTO P_START_DATE
66: FROM
67: RA_CUSTOMER_TRX_ALL CUTX,
68: JAI_AR_TRXS JCUTX,
69: RA_CUSTOMER_TRX_LINES_ALL CUTXL,
70: JAI_CMN_CUS_ADDRESSES JCUAD,
71: JAI_AR_TRX_TAX_LINES JRCTAXL,
72: JAI_CMN_TAXES_ALL JITC,
73: AR_PAYMENT_SCHEDULES_ALL ARPS

Line 208: V_LINE_AMOUNT RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT%TYPE;

204:
205: FUNCTION CF_1FORMULA0005(CUSTOMER_TRX_ID IN NUMBER
206: ,ORDER_LINE_ID IN VARCHAR2
207: ,LINE_AMOUNT IN NUMBER) RETURN NUMBER IS
208: V_LINE_AMOUNT RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT%TYPE;
209: CURSOR C_LINE_AMOUNT(CP_LINE_TYPE IN RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE) IS
210: SELECT
211: SUM(NVL(EXTENDED_AMOUNT
212: ,0))

Line 209: CURSOR C_LINE_AMOUNT(CP_LINE_TYPE IN RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE) IS

205: FUNCTION CF_1FORMULA0005(CUSTOMER_TRX_ID IN NUMBER
206: ,ORDER_LINE_ID IN VARCHAR2
207: ,LINE_AMOUNT IN NUMBER) RETURN NUMBER IS
208: V_LINE_AMOUNT RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT%TYPE;
209: CURSOR C_LINE_AMOUNT(CP_LINE_TYPE IN RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE) IS
210: SELECT
211: SUM(NVL(EXTENDED_AMOUNT
212: ,0))
213: FROM

Line 214: RA_CUSTOMER_TRX_LINES_ALL

210: SELECT
211: SUM(NVL(EXTENDED_AMOUNT
212: ,0))
213: FROM
214: RA_CUSTOMER_TRX_LINES_ALL
215: WHERE CUSTOMER_TRX_ID = CF_1FORMULA0005.CUSTOMER_TRX_ID
216: AND LINE_TYPE = CP_LINE_TYPE
217: AND SALES_ORDER_LINE = ORDER_LINE_ID
218: GROUP BY