APPS.ARP_PROCESS_RCTS dependencies on AR_CASH_RECEIPT_HISTORY

Line 371: -- AR_CASH_RECEIPT_HISTORY record.

367:
368: arp_cash_receipts_pkg.delete_p(p_cash_receipt_id);
369:
370: -- delete AR_DISTRIBUTIONS records created for each
371: -- AR_CASH_RECEIPT_HISTORY record.
372:
373: DELETE AR_DISTRIBUTIONS
374: WHERE source_table = 'CRH'
375: AND source_id IN (

Line 377: FROM ar_cash_receipt_history

373: DELETE AR_DISTRIBUTIONS
374: WHERE source_table = 'CRH'
375: AND source_id IN (
376: SELECT cash_receipt_history_id
377: FROM ar_cash_receipt_history
378: WHERE cash_receipt_id = p_cash_receipt_id)
379: RETURNING line_id
380: BULK COLLECT INTO l_ar_dist_key_value_list;
381:

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

398: ARP_XLA_EVENTS.delete_event( p_document_id => p_cash_receipt_id,
399: p_doc_table => 'CRH');
400:
401:
402: -- delete all AR_CASH_RECEIPT_HISTORY records created for this
403: -- receipt:
404: -- Bug 2021718: Call entity handler for delete
405: arp_cr_history_pkg.delete_p_cr(p_cash_receipt_id);
406:

Line 407: -- DELETE AR_CASH_RECEIPT_HISTORY

403: -- receipt:
404: -- Bug 2021718: Call entity handler for delete
405: arp_cr_history_pkg.delete_p_cr(p_cash_receipt_id);
406:
407: -- DELETE AR_CASH_RECEIPT_HISTORY
408: -- WHERE cash_receipt_id = p_cash_receipt_id;
409:
410: --Delete all associated accounting with the receivable applications
411: --first.

Line 655: FROM AR_CASH_RECEIPT_HISTORY

651: Properly . */
652:
653: SELECT count(distinct status)
654: INTO l_rec_moved_state
655: FROM AR_CASH_RECEIPT_HISTORY
656: WHERE cash_receipt_id = p_cr_id;
657:
658: IF (l_rec_moved_state > 1) THEN
659: p_rec_moved_state_flag := 'Y';

Line 684: ar_cash_receipt_history crh_cb

680: FROM
681: ce_statement_headers cb_sh,
682: ce_statement_lines cb_sl,
683: ce_statement_recon_gt_v cb_sr,
684: ar_cash_receipt_history crh_cb
685: WHERE
686: crh_cb.cash_receipt_id = p_cr_id
687: AND crh_cb.cash_receipt_history_id = cb_sr.reference_id (+)
688: AND cb_sr.reference_type (+) = 'RECEIPT'

Line 945: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra

941: FROM dual
942: WHERE
943: EXISTS
944: ( SELECT 1
945: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra
946: WHERE crh.cash_receipt_id = ra.application_ref_id
947: AND ra.cash_receipt_id = p_cr_id
948: AND ra.applied_payment_schedule_id+0 in (-6 , -9)
949: AND ra.application_ref_type = 'MISC_RECEIPT'

Line 971: from ar_cash_receipt_history crh_conf

967: select crh_conf.trx_date,
968: crh_conf.gl_date
969: into p_confirm_date,
970: p_confirm_gl_date
971: from ar_cash_receipt_history crh_conf
972: where crh_conf.cash_receipt_id = p_cr_id
973: and crh_conf.status = 'CONFIRMED'
974: and not exists (
975: select cash_receipt_history_id

Line 976: from ar_cash_receipt_history crh2

972: where crh_conf.cash_receipt_id = p_cr_id
973: and crh_conf.status = 'CONFIRMED'
974: and not exists (
975: select cash_receipt_history_id
976: from ar_cash_receipt_history crh2
977: where crh2.status = 'CONFIRMED'
978: and crh2.cash_receipt_id = p_cr_id
979: and crh2.cash_receipt_history_id > crh_conf.cash_receipt_history_id);
980: EXCEPTION

Line 1032: from ar_cash_receipt_history crh_current

1028: WHEN no_data_found THEN
1029:
1030: select crh_current.gl_date
1031: into p_reversal_gl_date
1032: from ar_cash_receipt_history crh_current
1033: where crh_current.cash_receipt_id = p_cr_id
1034: and crh_current.current_record_flag = 'Y';
1035:
1036: p_debit_memo := 'N';

Line 1100: FROM ar_cash_receipt_history

1096: INTO l_posted_flag
1097: FROM dual
1098: WHERE EXISTS
1099: (SELECT 'posted distribution exists'
1100: FROM ar_cash_receipt_history
1101: WHERE cash_receipt_id = p_cash_receipt_id
1102: AND gl_posted_date IS NOT NULL);
1103:
1104: IF (l_posted_flag ='Y')