APPS.AR_RECEIPT_VAL_PVT dependencies on AR_CASH_RECEIPT_HISTORY

Line 993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

Line 2475: ar_cash_receipt_history crh

2471:
2472: SELECT count(*)
2473: INTO l_valid
2474: FROM ar_cash_receipts cr,
2475: ar_cash_receipt_history crh
2476: WHERE cr.cash_receipt_id = p_cash_receipt_id
2477: and cr.cash_receipt_id = crh.cash_receipt_id
2478: and crh.current_record_flag = 'Y'
2479: and crh.status

Line 2787: l_status ar_cash_receipt_history.status%TYPE;

2783: p_applied_ps_id IN NUMBER,
2784: p_return_status IN OUT NOCOPY VARCHAR2
2785: ) IS
2786: l_payment_type VARCHAR2(30);
2787: l_status ar_cash_receipt_history.status%TYPE;
2788:
2789: BEGIN
2790:
2791: --If the applied payment schedule_id -7, we can issue the refund only to credit card.

Line 2835: FROM ar_cash_receipt_history

2831:
2832:
2833: BEGIN
2834: SELECT status INTO l_status
2835: FROM ar_cash_receipt_history
2836: WHERE cash_receipt_id = p_cash_receipt_id
2837: AND current_record_flag = 'Y';
2838:
2839: IF l_status NOT IN ('REMITTED', 'CLEARED') THEN