APPS.PSA_XFR_TO_GL_PKG dependencies on AR_CASH_RECEIPTS

Line 425: SELECT cr.cash_receipt_id FROM ar_cash_receipts cr, ar_cash_receipt_history crh

421: (SELECT cash_receipt_history_id FROM psa_misc_posting);
422:
423: CURSOR c_create_dist
424: IS
425: SELECT cr.cash_receipt_id FROM ar_cash_receipts cr, ar_cash_receipt_history crh
426: WHERE cr.cash_receipt_id = crh.cash_receipt_id
427: AND crh.posting_control_id = l_pst_ctrl_id;
428:
429:

Line 467: ar_cash_receipts cr,

463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,
468: ar_cash_receipt_history crh,
469: ar_distributions ard2
470: WHERE
471: l1.lookup_type = 'PSA_CARTESIAN_JOIN'

Line 526: ar_cash_receipts cr

522: FROM
523: ar_cash_receipt_history crh,
524: psa_receivables_trx_all psa,
525: ar_distributions ard,
526: ar_cash_receipts cr
527: WHERE
528: crh.status <> 'REVERSED'
529: AND crh.posting_control_id = l_pst_ctrl_id
530: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 584: ar_cash_receipts cr,

580: FROM
581: psa_mf_misc_dist_all mfd,
582: psa_lookup_codes l1,
583: ar_misc_cash_distributions mcd,
584: ar_cash_receipts cr,
585: ar_cash_receipt_history crh,
586: ar_cash_receipt_history crhold
587: WHERE
588: mfd.reference1 = 'CLEARED'

Line 1601: ar_cash_receipts cr,

1597: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
1598: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
1599: FROM
1600: ar_receivable_applications ra,
1601: ar_cash_receipts cr,
1602: (SELECT * FROM ar_distributions
1603: WHERE source_table = 'RA'
1604: AND source_id = p_receivable_application_id
1605: AND rownum = 1) ard,

Line 1811: ar_cash_receipts cr,

1807: ref29,
1808: 'PSA_RCT_DIST' ref30
1809: FROM
1810: ar_receivable_applications ra,
1811: ar_cash_receipts cr,
1812: (SELECT * FROM ar_distributions
1813: WHERE source_table = 'RA'
1814: AND source_id = p_receivable_application_id
1815: AND rownum = 1) ard,

Line 3872: ar_cash_receipts cr,

3868: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
3869: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
3870: FROM
3871: ar_receivable_applications ra,
3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
3875: ra_cust_trx_types ctt,
3876: ar_cash_receipt_history crh,

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')