APPS.ARP_TRX_COMPLETE_CHK dependencies on AR_CASH_RECEIPTS

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

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

Line 2181: AR_CASH_RECEIPTS WHERE cash_receipt_id=p_reversed_cash_receipt_id;

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