APPS.PSA_MFAR_RECEIPTS dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 105: FROM ar_cash_receipt_history_all crh,

101:
102: CURSOR c_crh
103: IS
104: SELECT distinct crh.status , crh.cash_receipt_id
105: FROM ar_cash_receipt_history_all crh,
106: ar_receivable_applications_all ra
107: WHERE crh.cash_receipt_id = ra.cash_receipt_id
108: AND ra.receivable_application_id = p_receivable_app_id
109: ORDER BY crh.status desc;

Line 132: ar_cash_receipt_history_all crh

128: CURSOR c_cash_ccid (c_cash_receipt_id NUMBER, c_status IN varchar2)
129: IS
130: SELECT crh.account_code_combination_id cash_ccid, crh.status
131: FROM ar_cash_receipts_all cr,
132: ar_cash_receipt_history_all crh
133: WHERE cr.cash_receipt_id = c_cash_receipt_id
134: AND cr.cash_receipt_id = crh.cash_receipt_id
135: AND crh.status = c_status
136: AND NOT (cr.type = 'MISC');