APPS.PSA_XFR_TO_GL_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh

4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:
4122: CURSOR c_create_dist
4123: IS
4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh
4125: WHERE cr.cash_receipt_id = crh.cash_receipt_id
4126: -- AND crh.status = 'CLEARED'
4127: AND fnd_date.date_to_canonical (crh.gl_date) BETWEEN fnd_date.date_to_canonical (TO_DATE (l_gl_start_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'))
4128: AND fnd_date.date_to_canonical (TO_DATE (l_post_through_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'));

Line 4162: ar_cash_receipts_all cr,

4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,
4161: ar_distributions_all ard,
4162: ar_cash_receipts_all cr,
4163: ar_cash_receipt_history_all crh
4164: WHERE
4165: l1.lookup_type = 'PSA_CARTESIAN_JOIN'
4166: AND l1.lookup_code IN ('1','2')