APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 73: AR_CASH_RECEIPT_HISTORY_ALL

69: AND EXISTS (
70: SELECT
71: 1
72: FROM
73: AR_CASH_RECEIPT_HISTORY_ALL
74: WHERE CASH_RECEIPT_ID = A.CASH_RECEIPT_ID
75: AND ORG_ID = P_ORG_ID
76: AND TRUNC(GL_DATE) < TRUNC(P_START_DATE) );
77: CURSOR GET_REVERSAL_AMOUNT IS

Line 84: AR_CASH_RECEIPT_HISTORY_ALL B

80: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
81: ,1.00)) SUM_AMOUNT_EXCHANGE
82: FROM
83: AR_CASH_RECEIPTS_ALL A,
84: AR_CASH_RECEIPT_HISTORY_ALL B
85: WHERE A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
86: AND A.PAY_FROM_CUSTOMER = CUSTOMER_ID
87: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)
88: AND A.REVERSAL_DATE is not null

Line 154: AR_CASH_RECEIPT_HISTORY_ALL B,

150: SUM(C.AMOUNT_APPLIED * NVL(A.EXCHANGE_RATE
151: ,1.00)) SUM_AMOUNT_EXCHANGE
152: FROM
153: AR_CASH_RECEIPTS_ALL A,
154: AR_CASH_RECEIPT_HISTORY_ALL B,
155: AR_RECEIVABLE_APPLICATIONS_ALL C
156: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
157: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)
158: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID

Line 171: AR_CASH_RECEIPT_HISTORY_ALL

167: AND not exists (
168: SELECT
169: 1
170: FROM
171: AR_CASH_RECEIPT_HISTORY_ALL
172: WHERE CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
173: AND STATUS = LV_REV_STATUS );
174: V_TR_DR_AMT NUMBER;
175: V_FUNC_DR_AMT NUMBER;

Line 359: AR_CASH_RECEIPT_HISTORY_ALL

355: AND EXISTS (
356: SELECT
357: 1
358: FROM
359: AR_CASH_RECEIPT_HISTORY_ALL
360: WHERE CASH_RECEIPT_ID = A.CASH_RECEIPT_ID
361: AND ORG_ID = P_ORG_ID
362: AND TRUNC(GL_DATE) <= TRUNC(P_END_DATE) );
363: CURSOR GET_REVERSAL_AMOUNT IS

Line 370: AR_CASH_RECEIPT_HISTORY_ALL B

366: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
367: ,1.00)) SUM_AMOUNT_EXCHANGE
368: FROM
369: AR_CASH_RECEIPTS_ALL A,
370: AR_CASH_RECEIPT_HISTORY_ALL B
371: WHERE A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
372: AND A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
373: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)
374: AND A.REVERSAL_DATE is not null

Line 440: AR_CASH_RECEIPT_HISTORY_ALL B,

436: SUM(C.AMOUNT_APPLIED * NVL(A.EXCHANGE_RATE
437: ,1.00)) SUM_AMOUNT_EXCHANGE
438: FROM
439: AR_CASH_RECEIPTS_ALL A,
440: AR_CASH_RECEIPT_HISTORY_ALL B,
441: AR_RECEIVABLE_APPLICATIONS_ALL C
442: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
443: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)
444: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID

Line 457: AR_CASH_RECEIPT_HISTORY_ALL

453: AND not exists (
454: SELECT
455: 1
456: FROM
457: AR_CASH_RECEIPT_HISTORY_ALL
458: WHERE CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
459: AND STATUS = LV_REV_STATUS );
460: V_TR_DISC_CR_AMT NUMBER;
461: V_FUNC_DISC_CR_AMT NUMBER;