APPS.AR_ARXINREV_XMLP_PKG dependencies on AR_ADJUSTMENTS

Line 324: from ar_adjustments adj

320: begin
321: /*srw.reference(C_PAY_ID);*/null;
322: select sum(amount)
323: into adjust
324: from ar_adjustments adj
325: where adj.payment_schedule_id = C_PAY_ID
326: and adj.gl_date <= P_END_DATE
327: and adj.status = 'A';
328: return(adjust);

Line 440: from ar_adjustments adj

436: /*srw.reference(C_PAY_ID);*/null;
437: /*srw.reference(C_OPEN_ORIG);*/null;
438: select sum(amount)
439: into adjust
440: from ar_adjustments adj
441: where adj.payment_schedule_id = C_PAY_ID
442: and adj.gl_date > P_REVALUATION_DATE
443: and adj.status = 'APP';
444: ratio := C_OPEN_ORIG/(C_OPEN_ORIG + ADJUST);