APPS.ARP_PROCESS_RCTS dependencies on AR_CASH_RECEIPT_HISTORY

Line 389: -- AR_CASH_RECEIPT_HISTORY record.

385:
386: arp_cash_receipts_pkg.delete_p(p_cash_receipt_id);
387:
388: -- delete AR_DISTRIBUTIONS records created for each
389: -- AR_CASH_RECEIPT_HISTORY record.
390:
391: DELETE AR_DISTRIBUTIONS
392: WHERE source_table = 'CRH'
393: AND source_id IN (

Line 395: FROM ar_cash_receipt_history

391: DELETE AR_DISTRIBUTIONS
392: WHERE source_table = 'CRH'
393: AND source_id IN (
394: SELECT cash_receipt_history_id
395: FROM ar_cash_receipt_history
396: WHERE cash_receipt_id = p_cash_receipt_id);
397: --Commented for bug 12989298
398: --RETURNING line_id
399: --BULK COLLECT INTO l_ar_dist_key_value_list;

Line 421: -- delete all AR_CASH_RECEIPT_HISTORY records created for this

417: ARP_XLA_EVENTS.delete_event( p_document_id => p_cash_receipt_id,
418: p_doc_table => 'CRH');
419:
420:
421: -- delete all AR_CASH_RECEIPT_HISTORY records created for this
422: -- receipt:
423: -- Bug 2021718: Call entity handler for delete
424: arp_cr_history_pkg.delete_p_cr(p_cash_receipt_id);
425:

Line 426: -- DELETE AR_CASH_RECEIPT_HISTORY

422: -- receipt:
423: -- Bug 2021718: Call entity handler for delete
424: arp_cr_history_pkg.delete_p_cr(p_cash_receipt_id);
425:
426: -- DELETE AR_CASH_RECEIPT_HISTORY
427: -- WHERE cash_receipt_id = p_cash_receipt_id;
428:
429: --Delete all associated accounting with the receivable applications
430: --first.

Line 700: FROM AR_CASH_RECEIPT_HISTORY

696: Properly . */
697:
698: SELECT count(distinct status)
699: INTO l_rec_moved_state
700: FROM AR_CASH_RECEIPT_HISTORY
701: WHERE cash_receipt_id = p_cr_id;
702:
703: IF (l_rec_moved_state > 1) THEN
704: p_rec_moved_state_flag := 'Y';

Line 712: FROM AR_CASH_RECEIPT_HISTORY

708:
709: -- bug 16180140
710: SELECT status
711: INTO l_status
712: FROM AR_CASH_RECEIPT_HISTORY
713: WHERE cash_receipt_id = p_cr_id
714: AND current_record_flag = 'Y';
715:
716: -- get the cash management items

Line 735: ar_cash_receipt_history crh_cb

731: FROM
732: ce_statement_headers cb_sh,
733: ce_statement_lines cb_sl,
734: ce_statement_reconcils_ou cb_sr,
735: ar_cash_receipt_history crh_cb
736: WHERE
737: crh_cb.cash_receipt_id = p_cr_id
738: AND crh_cb.cash_receipt_history_id = cb_sr.reference_id (+)
739: AND nvl(crh_cb.current_record_flag,'N') = Decode(l_status,'REVERSED','Y',

Line 998: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra

994: FROM dual
995: WHERE
996: EXISTS
997: ( SELECT 1
998: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra
999: WHERE crh.cash_receipt_id = ra.application_ref_id
1000: AND ra.cash_receipt_id = p_cr_id
1001: AND ra.applied_payment_schedule_id+0 in (-6 , -9)
1002: AND ra.application_ref_type = 'MISC_RECEIPT'

Line 1024: from ar_cash_receipt_history crh_conf

1020: select crh_conf.trx_date,
1021: crh_conf.gl_date
1022: into p_confirm_date,
1023: p_confirm_gl_date
1024: from ar_cash_receipt_history crh_conf
1025: where crh_conf.cash_receipt_id = p_cr_id
1026: and crh_conf.status = 'CONFIRMED'
1027: and not exists (
1028: select cash_receipt_history_id

Line 1029: from ar_cash_receipt_history crh2

1025: where crh_conf.cash_receipt_id = p_cr_id
1026: and crh_conf.status = 'CONFIRMED'
1027: and not exists (
1028: select cash_receipt_history_id
1029: from ar_cash_receipt_history crh2
1030: where crh2.status = 'CONFIRMED'
1031: and crh2.cash_receipt_id = p_cr_id
1032: and crh2.cash_receipt_history_id > crh_conf.cash_receipt_history_id);
1033: EXCEPTION

Line 1085: from ar_cash_receipt_history crh_current

1081: WHEN no_data_found THEN
1082:
1083: select crh_current.gl_date
1084: into p_reversal_gl_date
1085: from ar_cash_receipt_history crh_current
1086: where crh_current.cash_receipt_id = p_cr_id
1087: and crh_current.current_record_flag = 'Y';
1088:
1089: p_debit_memo := 'N';

Line 1153: FROM ar_cash_receipt_history

1149: INTO l_posted_flag
1150: FROM dual
1151: WHERE EXISTS
1152: (SELECT 'posted distribution exists'
1153: FROM ar_cash_receipt_history
1154: WHERE cash_receipt_id = p_cash_receipt_id
1155: AND gl_posted_date IS NOT NULL);
1156:
1157: IF (l_posted_flag ='Y')