DBA Data[Home] [Help]

APPS.ARP_PROCESS_RETURNS dependencies on AR_CASH_RECEIPT_HISTORY

Line 1506: FROM AR_CASH_RECEIPT_HISTORY crh

1502: (
1503: NOT EXISTS
1504: (
1505: SELECT 1
1506: FROM AR_CASH_RECEIPT_HISTORY crh
1507: WHERE crh.cash_receipt_id = p_cash_receipt_id
1508: AND crh.status IN ('REMITTED', 'CLEARED')
1509: )
1510: );

Line 1539: FROM AR_CASH_RECEIPT_HISTORY crh

1535: (
1536: NOT EXISTS
1537: (
1538: SELECT 1
1539: FROM AR_CASH_RECEIPT_HISTORY crh
1540: WHERE crh.cash_receipt_id = p_cash_receipt_id
1541: AND crh.status IN ('CLEARED')
1542: )
1543: );

Line 2050: FROM ar_cash_receipt_history

2046:
2047: BEGIN
2048: SELECT gl_date
2049: INTO l_rec_gl_date
2050: FROM ar_cash_receipt_history
2051: WHERE cash_receipt_id = p_ra_rec.cash_receipt_id
2052: AND first_posted_record_flag = 'Y';
2053: EXCEPTION
2054: WHEN OTHERS THEN