DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on AR_CASH_RECEIPT_HISTORY

Line 984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

Line 2405: ar_cash_receipt_history crh

2401:
2402: SELECT count(*)
2403: INTO l_valid
2404: FROM ar_cash_receipts cr,
2405: ar_cash_receipt_history crh
2406: WHERE cr.cash_receipt_id = p_cash_receipt_id
2407: and cr.cash_receipt_id = crh.cash_receipt_id
2408: and crh.current_record_flag = 'Y'
2409: and crh.status