DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on DUAL

Line 2520: FROM sys.dual

2516:
2517: insert into fnd_sessions
2518: (session_id, effective_date)
2519: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2520: FROM sys.dual
2521: WHERE not exists
2522: (SELECT 1
2523: FROM fnd_sessions fs
2524: WHERE fs.session_id = userenv('sessionid')) ;

Line 2639: SELECT XDO_CP_DATA_SECURITY_PKG.GET_CONCURRENT_REQUEST_IDS FROM DUAL;

2635: l_arg1_result VARCHAR2(10);
2636: l_arg7_result VARCHAR2(10);
2637:
2638: CURSOR get_l_arg1_result IS
2639: SELECT XDO_CP_DATA_SECURITY_PKG.GET_CONCURRENT_REQUEST_IDS FROM DUAL;
2640:
2641: CURSOR get_l_arg7_result IS
2642: select template_type_code from xdo_templates_vl where template_code = p_template and application_short_name = (select application_short_name from fnd_application_vl where application_id = 801);
2643: