APPS.BIX_PMV_DBI_UTL_PKG dependencies on DUAL

Line 568: '(Select dummy from dual)'

564: THEN 'HZ_PARTIES'
565: WHEN g_agent_group_dim
566: THEN 'JTF_RS_RESOURCE_EXTNS_VL'
567: ELSE
568: '(Select dummy from dual)'
569: END
570: );
571:
572: RETURN l_table;

Line 1794: FROM dual;

1790: --SELECT to_char(add_months(to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),
1791: --'MM/DD/YYYY'),13),'DD-MON-YYYY')
1792: SELECT to_char(sysdate,'DD-MON-YYYY')
1793: INTO v_date
1794: FROM dual;
1795: RETURN 'BIX_PMV_WEEK_FROM=ALL&BIX_PMV_WEEK_TO=ALL&BIX_PMV_SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL&AS_OF_DATE='||v_date;
1796: EXCEPTION
1797: WHEN OTHERS
1798: THEN

Line 1881: FROM dual;

1877: v_date VARCHAR2(11);
1878: BEGIN
1879: SELECT to_char(sysdate,'DD-MON-YYYY')
1880: INTO v_date
1881: FROM dual;
1882: RETURN 'FII_TIME_WEEK_FROM=All&FII_TIME_WEEK_TO=All&SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL&AS_OF_DATE='||v_date;
1883: EXCEPTION
1884: WHEN OTHERS
1885: THEN

Line 1984: FROM dual;

1980: v_date VARCHAR2(11);
1981: BEGIN
1982: SELECT to_char(sysdate,'DD-MON-YYYY')
1983: INTO v_date
1984: FROM dual;
1985: RETURN '+FII_TIME_ENT_PERIOD=TIME+FII_TIME_ENT_PERIOD+SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL='||v_date;
1986: EXCEPTION
1987: WHEN OTHERS
1988: THEN