APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_CRH_GT

Line 4091: INSERT INTO ar_crh_gt (

4087: local_log(procedure_name => 'mfar_crh_dist',
4088: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_crh_dist ()+');
4089: -- All CRH distribution part of the current posting will serve for the
4090: -- Additional distribution building
4091: INSERT INTO ar_crh_gt (
4092: cash_receipt_id ,
4093: cash_receipt_history_id,
4094: source_type ,
4095: posting_control_id ,

Line 4296: FROM ar_crh_gt crh,

4292: ,app.third_party_id --third_party_id
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,

Line 4760: FROM ar_crh_gt crh,

4756: --
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'