18: and source_type=p2_status;
19:
20: CURSOR app_amount is
21: select amount_applied
22: from ar_receivable_applications
23: where applied_customer_trx_id=p_customer_trx_id
24: and status='APP'
25: and link_to_trx_hist_id=p_trh_id;
26:
83: and source_type=p2_status;
84:
85: CURSOR app_amount is
86: select amount_applied_from
87: from ar_receivable_applications
88: where applied_customer_trx_id=p_customer_trx_id
89: and status='APP'
90: and link_to_trx_hist_id=p_trh_id;
91: