DBA Data[Home] [Help]

APPS.FII_GL_COST_CENTER_PKG dependencies on DUAL

Line 306: FROM DUAL

302: NULL FII_MEASURE16,
303: NULL FII_MEASURE17,
304: NULL FII_MEASURE18
305:
306: FROM DUAL
307: WHERE 1=2 ';
308:
309: ELSE
310:

Line 699: FROM dual;

695: END IF;
696:
697: SELECT fii_time_api.ent_sd_lysper_end(fii_gl_util_pkg.g_as_of_date)
698: INTO l_lyr
699: FROM dual;
700:
701: IF l_lyr is NOT NULL THEN
702: l_join1 := ' > to_date(:P_SD_LYR, ''DD-MM-YYYY'')';
703: l_join3 := '= to_date(:P_SD_LYR, ''DD-MM-YYYY'')';

Line 711: FROM dual;

707: END IF;
708:
709: SELECT fii_time_api.ent_sd_lysper_end(l_lyr)
710: INTO l_llyr
711: FROM dual;
712:
713: IF l_llyr is NOT NULL THEN
714: l_join2 := '> to_date(:PPY_SAME_DAY, ''DD-MM-YYYY'')';
715: ELSE

Line 725: FROM DUAL

721: sqlstmt := ' SELECT NULL VIEWBY,
722: NULL FII_MEASURE1,
723: NULL FII_MEASURE2,
724: NULL FII_MEASURE3
725: FROM DUAL
726: WHERE 1=2 ';
727:
728: ELSE
729:

Line 967: FROM DUAL

963: NULL FII_MEASURE13,
964: NULL FII_MEASURE14,
965: NULL FII_MEASURE15
966:
967: FROM DUAL
968: WHERE 1=2 ';
969:
970: ELSE
971: