APPS.AR_UPG_PSA_DIST_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 517: ar_cash_receipt_history_all crh

513: FROM ar_receivable_applications_all app,
514: ar_distributions_all ard,
515: (SELECT 'CASH' side FROM DUAL UNION
516: SELECT 'APP' side FROM DUAL ) double,
517: ar_cash_receipt_history_all crh
518: WHERE app.rowid >= l_start_rowid
519: AND app.rowid <= l_end_rowid
520: AND app.receivable_application_id = ard.source_id
521: AND ard.source_table = 'RA'

Line 952: ar_cash_receipt_history_all crh

948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,
952: ar_cash_receipt_history_all crh
953: WHERE app.rowid >= l_start_rowid
954: AND app.rowid <= l_end_rowid
955: AND app.receivable_application_id = a.receivable_application_id
956: AND a.cust_trx_line_gl_dist_id = psatd.cust_trx_line_gl_dist_id