APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on DUAL

Line 5723: FROM dual;

5719:
5720: END IF;
5721:
5722: SELECT ar_mfar_extract_s.nextval INTO l_ar_mfar_extract_s
5723: FROM dual;
5724:
5725: -- Assign the values to extract table
5726: l_cm_app_mfar_extract_tab(k).EVENT_ID := p_ar_cm_from_rec(i).EVENT_ID;
5727: l_cm_app_mfar_extract_tab(k).LINE_NUMBER := -1 * l_ar_mfar_extract_s;

Line 6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION

6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6113: SELECT 'REV_DIST' AS status FROM DUAL) state
6114: WHERE gt.application_id = 222
6115: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6116: AND gt.event_id = crh.event_id

Line 6113: SELECT 'REV_DIST' AS status FROM DUAL) state

6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6113: SELECT 'REV_DIST' AS status FROM DUAL) state
6114: WHERE gt.application_id = 222
6115: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6116: AND gt.event_id = crh.event_id
6117: AND crh.postable_flag = 'Y'

Line 6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION

6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6178: SELECT 'REV_DIST' AS status FROM DUAL) state
6179: WHERE gt.application_id = 222
6180: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6181: AND gt.event_id = crh.event_id

Line 6178: SELECT 'REV_DIST' AS status FROM DUAL) state

6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6178: SELECT 'REV_DIST' AS status FROM DUAL) state
6179: WHERE gt.application_id = 222
6180: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6181: AND gt.event_id = crh.event_id
6182: AND crh.postable_flag = 'Y'

Line 8066: FROM DUAL;

8062: IF p_accounting_mode = 'F' THEN
8063:
8064: SELECT ar_posting_control_s.NEXTVAL
8065: INTO l_pst_id
8066: FROM DUAL;
8067:
8068: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
8069: --
8070: -- CRH

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

8064: SELECT ar_posting_control_s.NEXTVAL
8065: INTO l_pst_id
8066: FROM DUAL;
8067:
8068: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
8069: --
8070: -- CRH
8071: -- GL Posting entiting are
8072: -- AR_CASH_RECEIPT_HISTORY_ALL,