APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on DUAL

Line 4298: (SELECT 'CLEARED' AS status FROM DUAL UNION

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
4302: WHERE crh.entity_id = app.entity_id

Line 4299: SELECT 'REMITTED' AS status FROM DUAL UNION

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
4302: WHERE crh.entity_id = app.entity_id
4303: AND app.source_table = 'RA'

Line 4300: SELECT 'CONFIRMED' AS status FROM DUAL ) state,

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
4302: WHERE crh.entity_id = app.entity_id
4303: AND app.source_table = 'RA'
4304: AND DECODE(state.status,'CLEARED' ,DECODE(crh.status,'CLEARED' ,'Y','N'),

Line 5409: FROM DUAL;

5405: IF p_accounting_mode = 'F' THEN
5406:
5407: SELECT ar_posting_control_s.NEXTVAL
5408: INTO l_pst_id
5409: FROM DUAL;
5410:
5411: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
5412: --
5413: -- CRH

Line 5411: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;

5407: SELECT ar_posting_control_s.NEXTVAL
5408: INTO l_pst_id
5409: FROM DUAL;
5410:
5411: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
5412: --
5413: -- CRH
5414: -- GL Posting entiting are
5415: -- AR_CASH_RECEIPT_HISTORY_ALL,