APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_CRH_APP_GT

Line 3922: DELETE FROM ar_crh_app_gt;

3918: mfar_produit_app_by_crh;
3919: --Create additional_distribution_for_ra
3920: mfar_get_ra;
3921: --Avoid contention between Cash Receipt and MCD
3922: DELETE FROM ar_crh_app_gt;
3923: -- Get all Misc Cash Distributions for the Misc receipts
3924: mfar_mcd_dist_cr;
3925: -- Create the times of addition distribution for MCD
3926: mfar_produit_mcd_by_crh;

Line 3953: INSERT INTO ar_crh_app_gt (

3949: --
3950: -- For a RECP_CREATE and RECP_UPDATE events
3951: -- All application distributions are necessary for the MFAR CRH building
3952: --
3953: INSERT INTO ar_crh_app_gt (
3954: entity_id
3955: ,receivable_application_id
3956: ,cash_receipt_history_id
3957: ,cash_receipt_history_status

Line 4297: ar_crh_app_gt app,

4293: ,app.third_party_site_id --third_party_site_id
4294: ,app.third_party_type --third_party_type
4295: ,app.source_type --source_type
4296: FROM ar_crh_gt crh,
4297: ar_crh_app_gt app,
4298: (SELECT 'CLEARED' AS status FROM DUAL UNION
4299: SELECT 'REMITTED' AS status FROM DUAL UNION
4300: SELECT 'CONFIRMED' AS status FROM DUAL ) state,
4301: xla_events_gt gt

Line 4519: INSERT INTO ar_crh_app_gt (

4515: PROCEDURE mfar_mcd_dist_cr IS
4516: BEGIN
4517: local_log(procedure_name => 'mfar_mcd_dist_cr',
4518: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()+');
4519: INSERT INTO ar_crh_app_gt (
4520: entity_id
4521: ,receivable_application_id
4522: ,cash_receipt_history_id
4523: ,cash_receipt_history_status

Line 4761: ar_crh_app_gt mcd,

4757: ,gt.event_type_code --EVENT_TYPE_CODE
4758: ,gt.event_class_code --EVENT_CLASS_CODE
4759: ,gt.entity_code --ENTITY_CODE
4760: FROM ar_crh_gt crh,
4761: ar_crh_app_gt mcd,
4762: xla_events_gt gt
4763: WHERE crh.entity_id = mcd.entity_id
4764: AND mcd.source_table = 'MCD'
4765: AND crh.event_id = gt.event_id;