DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on DUAL

Line 2400: FROM sys.dual

2396:
2397: insert into fnd_sessions
2398: (session_id, effective_date)
2399: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2400: FROM sys.dual
2401: WHERE not exists
2402: (SELECT 1
2403: FROM fnd_sessions fs
2404: WHERE fs.session_id = userenv('sessionid')) ;

Line 2519: SELECT XDO_CP_DATA_SECURITY_PKG.GET_CONCURRENT_REQUEST_IDS FROM DUAL;

2515: l_arg1_result VARCHAR2(10);
2516: l_arg7_result VARCHAR2(10);
2517:
2518: CURSOR get_l_arg1_result IS
2519: SELECT XDO_CP_DATA_SECURITY_PKG.GET_CONCURRENT_REQUEST_IDS FROM DUAL;
2520:
2521: CURSOR get_l_arg7_result IS
2522: 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);
2523: