DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on DUAL

Line 2559: INTO l_rep_context_id FROM dual;

2555:
2556:
2557: BEGIN
2558: SELECT zx_rep_context_t_s.nextval
2559: INTO l_rep_context_id FROM dual;
2560:
2561: IF (g_level_procedure >= g_current_runtime_level ) THEN
2562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2563: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');

Line 3248: select 'Y' from dual where exists

3244: begin
3245: /*cursor use_matrix_flag_csr_ar
3246: (c_report_id in number,
3247: c_attribute_set in varchar2 ) is
3248: select 'Y' from dual where exists
3249: (select '1'
3250: from FA_RX_REPORTS_V RV,
3251: FA_RX_ATTRSETS ATT,
3252: FA_RX_REP_COLUMNS COL

Line 3375: select 'Y' from dual where exists

3371:
3372: cursor use_matrix_flag_csr_ap
3373: (c_report_id in number,
3374: c_attribute_set in varchar2 ) is
3375: select 'Y' from dual where exists
3376: (select '1'
3377: from FA_RX_REPORTS_V RV,
3378: FA_RX_ATTRSETS ATT,
3379: FA_RX_REP_COLUMNS COL