APPS.ZX_EXTRACT_PKG dependencies on DUAL

Line 922: FROM dual;

918: || ':' ||
919: mod(floor((l_end_time-l_start_time)*24*60*60),60)
920: time_difference
921: INTO l_total_time
922: FROM dual;
923:
924:
925: FND_FILE.put_line(which => FND_FILE.LOG
926: ,buff => 'Total Time Taken :'||l_total_time);

Line 3018: INTO l_rep_context_id FROM dual;

3014:
3015:
3016: BEGIN
3017: SELECT zx_rep_context_t_s.nextval
3018: INTO l_rep_context_id FROM dual;
3019:
3020: IF (g_level_procedure >= g_current_runtime_level ) THEN
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3022: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');

Line 3744: select 'Y' from dual where exists

3740: begin
3741: /*cursor use_matrix_flag_csr_ar
3742: (c_report_id in number,
3743: c_attribute_set in varchar2 ) is
3744: select 'Y' from dual where exists
3745: (select '1'
3746: from FA_RX_REPORTS_V RV,
3747: FA_RX_ATTRSETS ATT,
3748: FA_RX_REP_COLUMNS COL

Line 3871: select 'Y' from dual where exists

3867:
3868: cursor use_matrix_flag_csr_ap
3869: (c_report_id in number,
3870: c_attribute_set in varchar2 ) is
3871: select 'Y' from dual where exists
3872: (select '1'
3873: from FA_RX_REPORTS_V RV,
3874: FA_RX_ATTRSETS ATT,
3875: FA_RX_REP_COLUMNS COL