APPS.FV_FACTS_TBAL_TRX dependencies on DUAL

Line 711: from dual

707:
708: --- added for bug 6409180
709: cursor be_cur is
710: select vl_legis_ref transaction_id, vl_legis_amount amount
711: from dual
712: where nvl(vl_je_sla_flag ,'N') = 'N'
713: union all
714: SELECT to_char(xd.source_distribution_id_num_1) transaction_id,
715: (NVL(xd.unrounded_accounted_dr,0) -

Line 912: FROM DUAL;

908: IF vl_cohort_yr IS NOT NULL THEN
909: BEGIN
910: SELECT TO_NUMBER(vl_cohort_yr)
911: INTO v_dummy_cohort
912: FROM DUAL;
913:
914: IF LENGTH(v_dummy_cohort) = 1 THEN
915: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,