APPS.FV_FACTS_TBAL_TRX dependencies on DUAL

Line 792: from dual

788:
789: --- added for bug 6409180
790: cursor be_cur is
791: select vl_legis_ref transaction_id, vl_legis_amount amount
792: from dual
793: where nvl(vl_je_sla_flag ,'N') = 'N'
794: union all
795: SELECT to_char(xd.source_distribution_id_num_1) transaction_id,
796: (NVL(xd.unrounded_accounted_dr,0) -

Line 1004: FROM DUAL;

1000: IF vl_cohort_yr IS NOT NULL THEN
1001: BEGIN
1002: SELECT TO_NUMBER(vl_cohort_yr)
1003: INTO v_dummy_cohort
1004: FROM DUAL;
1005:
1006: IF LENGTH(v_dummy_cohort) = 1 THEN
1007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1008: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,