APPS.ARP_TRX_COMPLETE_CHK dependencies on AR_CASH_RECEIPTS

Line 2172: /* step 1: Fetch the original receipt amount from ar_cash_receipts

2168: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2169: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2170: frt_amount ra_customer_trx_lines.gross_extended_amount%type;
2171: BEGIN
2172: /* step 1: Fetch the original receipt amount from ar_cash_receipts
2173: step 2: Fetch total amount from trx (dm)
2174: step 3: compare .
2175: step 4: if dm amount < origianl return "E"
2176: else return "S"

Line 2184: AR_CASH_RECEIPTS WHERE cash_receipt_id=p_reversed_cash_receipt_id;

2180: BEGIN
2181: SELECT amount INTO
2182: l_original_amount
2183: FROM
2184: AR_CASH_RECEIPTS WHERE cash_receipt_id=p_reversed_cash_receipt_id;
2185: EXCEPTION
2186: WHEN OTHERS THEN
2187: l_original_amount:=0;
2188: END;