APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 110: AR_ADJUSTMENTS_ALL A,

106: SUM(A.AMOUNT),
107: SUM(A.AMOUNT * NVL(B.EXCHANGE_RATE
108: ,1.00)) SUM_AMOUNT_EXCHANGE
109: FROM
110: AR_ADJUSTMENTS_ALL A,
111: AR_CASH_RECEIPTS_ALL B
112: WHERE A.ASSOCIATED_CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
113: AND B.PAY_FROM_CUSTOMER = CUSTOMER_ID
114: AND A.GL_DATE <= TRUNC(P_START_DATE)

Line 124: AR_ADJUSTMENTS_ALL B,

120: SUM(B.AMOUNT),
121: SUM(B.AMOUNT * NVL(C.EXCHANGE_RATE
122: ,1.00)) SUM_AMOUNT_EXCHANGE
123: FROM
124: AR_ADJUSTMENTS_ALL B,
125: RA_CUSTOMER_TRX_ALL C,
126: AR_PAYMENT_SCHEDULES_ALL D,
127: GL_CODE_COMBINATIONS E
128: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID

Line 407: FROM ar_adjustments_all A,

403:
404: Cursor get_adjustment_amount IS
405: SELECT SUM(A.amount),
406: SUM(A.amount * NVL(b.exchange_rate,1.00)) sum_amount_exchange
407: FROM ar_adjustments_all A,
408: ar_cash_receipts_all b
409: WHERE A.associated_cash_receipt_id = b.cash_receipt_id
410: and b.pay_from_customer = P_CUSTOMER_ID
411: --and trunc(a.apply_date) <= trunc( p_start_date)

Line 420: FROM ar_adjustments_all b,

416:
417: cursor c_get_nonfc_adj_amount is
418: select sum(b.amount),
419: sum(b.amount * NVL(c.exchange_rate,1.00)) sum_amount_exchange
420: FROM ar_adjustments_all b,
421: ra_customer_trx_all c,
422: ar_payment_schedules_all d,
423: gl_code_combinations e
424: WHERE