APPS.OKI_DBI_NSCM_EXP_PVT dependencies on DUAL

Line 671: FROM dual;

667: p_norenewal
668: END
669: INTO
670: l_retval
671: FROM dual;
672:
673: RETURN l_retval;
674:
675: END exptype_detail;

Line 766: from dual;

762: l_exp_type_filter:=' AND exp_renewal_flag <> 0';
763: else
764: select ' AND exp_renewal_flag='||decode(l_exp_type,'''1''','2','''2''','1','''3''','4','''4''','8')
765: into l_exp_type_filter
766: from dual;
767: end if;
768:
769: l_rpt_specific_where:=l_rpt_specific_where||l_exp_type_filter;
770:

Line 937: SELECT DECODE (l_exp_type, '''1''', 2, '''2''', 1,'''3''', 4,'''4''', 8) INTO l_exp_renewal_flag FROM DUAL;

933: , p_rg_where => 'Y');
934:
935: l_exp_type := OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+EXP_TYPE');
936:
937: SELECT DECODE (l_exp_type, '''1''', 2, '''2''', 1,'''3''', 4,'''4''', 8) INTO l_exp_renewal_flag FROM DUAL;
938:
939:
940: l_rpt_specific_where := ' AND fact.effective_expire_date between &BIS_CURRENT_EFFECTIVE_START_DATE
941: and &BIS_CURRENT_EFFECTIVE_END_DATE