APPS.PSA_MF_MISC_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 47: FROM ar_cash_receipt_history

43: CURSOR c_crh_status
44: IS
45: SELECT cash_receipt_history_id,status, reversal_cash_receipt_hist_id,
46: prv_stat_cash_receipt_hist_id
47: FROM ar_cash_receipt_history
48: WHERE cash_receipt_id = p_cash_receipt_id
49: ORDER BY cash_receipt_history_id;
50:
51: CURSOR c_match_ccid (p_status IN varchar2)

Line 352: -- Cash Mgt - c_cash_ccid is modified to choose the A/c from ar_cash_receipt_history_all

348:
349: -- Bug3963328
350: -- AND SYSDATE BETWEEN NVL(acc.start_date, SYSDATE) AND NVL(acc.end_date, SYSDATE);
351:
352: -- Cash Mgt - c_cash_ccid is modified to choose the A/c from ar_cash_receipt_history_all
353: -- This table stores the ccid based on the activity - Remittance A/c or Cash A/c
354:
355: CURSOR c_mfar_dist_rec IS
356: SELECT crh.status curstatus, crh1.status prevstatus

Line 357: FROM ar_cash_receipt_history crh, ar_cash_receipt_history crh1

353: -- This table stores the ccid based on the activity - Remittance A/c or Cash A/c
354:
355: CURSOR c_mfar_dist_rec IS
356: SELECT crh.status curstatus, crh1.status prevstatus
357: FROM ar_cash_receipt_history crh, ar_cash_receipt_history crh1
358: WHERE crh.cash_receipt_history_id = x_cash_receipt_hist_id AND
359: crh.cash_receipt_history_id = crh1.reversal_cash_receipt_hist_id(+);
360:
361: CURSOR c_reversal_ccid(p_misc_dist_id in number) IS

Line 681: FROM ar_cash_receipt_history

677: ' Create_distributions --> Calling psa_mf_misc_dist_all_pkg.insert_row ');
678: -- ========================= FND LOG ===========================
679:
680: SELECT first_posted_record_flag INTO first_rec_flag
681: FROM ar_cash_receipt_history
682: WHERE cash_receipt_history_id = x_cash_receipt_hist_id;
683:
684: IF first_rec_flag = 'N' AND x_status = 'CLEARED' THEN
685: OPEN c_reversal_ccid(l_misc_dist_rec.misc_cash_distribution_id);