APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on XLA_POST_ACCTG_EVENTS_V

Line 5424: FROM xla_post_acctg_events_v ev

5420: gl_posted_date = l_date
5421: WHERE posting_control_id = -3
5422: AND (cash_receipt_id, event_id) IN
5423: (SELECT ev.source_id_int_1, ev.event_id
5424: FROM xla_post_acctg_events_v ev
5425: WHERE ev.application_id = p_application_id
5426: AND ev.process_status_code = 'P'
5427: AND ev.event_type_code IN
5428: ('RECP_CREATE' ,

Line 5443: FROM xla_post_acctg_events_v ev

5439: gl_posted_date = l_date
5440: WHERE posting_control_id = -3
5441: AND (cash_receipt_id, event_id) IN
5442: (SELECT ev.source_id_int_1, ev.event_id
5443: FROM xla_post_acctg_events_v ev
5444: WHERE ev.application_id = p_application_id
5445: AND ev.process_status_code = 'P'
5446: AND ev.event_type_code IN
5447: ('MISC_RECP_CREATE' ,

Line 5464: FROM xla_post_acctg_events_v ev

5460: gl_posted_date = l_date
5461: WHERE posting_control_id = -3
5462: AND (customer_trx_id, event_id) IN
5463: (SELECT ev.source_id_int_1, ev.event_id
5464: FROM xla_post_acctg_events_v ev
5465: WHERE ev.application_id = p_application_id
5466: AND ev.process_status_code = 'P'
5467: AND ev.event_type_code IN
5468: ('INV_CREATE' , 'INV_UPDATE' ,

Line 5486: FROM xla_post_acctg_events_v ev

5482: gl_posted_date = l_date
5483: WHERE posting_control_id = -3
5484: AND adjustment_id IN
5485: (SELECT ev.source_id_int_1
5486: FROM xla_post_acctg_events_v ev
5487: WHERE ev.application_id = p_application_id
5488: AND ev.process_status_code = 'P'
5489: AND ev.event_type_code = 'ADJ_CREATE');
5490:

Line 5502: FROM xla_post_acctg_events_v ev

5498: gl_posted_date = l_date
5499: WHERE posting_control_id = -3
5500: AND event_id IN
5501: (SELECT ev.event_id
5502: FROM xla_post_acctg_events_v ev
5503: WHERE ev.application_id = p_application_id
5504: AND ev.process_status_code = 'P'
5505: AND ev.event_type_code IN
5506: ('CM_CREATE' ,'CM_UPDATE' ,

Line 5523: FROM xla_post_acctg_events_v ev

5519: WHERE posting_control_id = -3
5520: AND postable_flag='Y'
5521: AND event_id IN
5522: (SELECT ev.event_id
5523: FROM xla_post_acctg_events_v ev
5524: WHERE ev.application_id = p_application_id
5525: AND ev.process_status_code = 'P'
5526: AND ev.event_type_code IN
5527: ( 'BILL_CREATE' ,