APPS.AR_RAXCBR_XMLP_PKG dependencies on AR_ADJUSTMENTS

Line 88: from ar_adjustments

84: ELSE
85: IF commit_type = 'GUAR' THEN
86: select nvl(sum(amount), 0)
87: into adjusted_amount
88: from ar_adjustments
89: where customer_trx_id = customer_trx_id1
90: and subsequent_trx_id = child_customer_trx_id
91: and adjustment_type = 'C';
92:

Line 97: from ar_adjustments

93: RETURN( -adjusted_amount);
94: ELSE
95: select nvl(sum(amount),0)
96: into adjusted_amount
97: from ar_adjustments
98: where customer_trx_id = child_customer_trx_id
99: and subsequent_trx_id is null
100: and adjustment_type = 'C';
101:

Line 431: from ar_adjustments

427: IF source1 = 'PS' THEN
428: IF commit_type = 'DEP' THEN
429: select nvl(sum(amount),0)
430: into adjusted_amount
431: from ar_adjustments
432: where customer_trx_id = child_customer_trx_id
433: and subsequent_trx_id = child_cm_customer_trx_id
434: and adjustment_type = 'C';
435:

Line 441: from ar_adjustments

437: RETURN( -adjusted_amount);
438: ELSE
439: select nvl(sum(amount), 0)
440: into adjusted_amount
441: from ar_adjustments
442: where customer_trx_id = customer_trx_id1
443: and subsequent_trx_id = child_cm_customer_trx_id
444: and adjustment_type = 'C';
445: