APPS.WIP_BIS_YDSP_ALERT dependencies on DUAL

Line 82: p_from_geo VARCHAR2(1000) := 'sys.dual';

78: p_select_product VARCHAR2(1000) := 'to_char(NULL) ';
79:
80: /* FROM clause */
81: p_from VARCHAR2(1000) := 'WIP_BIS_PROD_DEPT_YIELD_V';
82: p_from_geo VARCHAR2(1000) := 'sys.dual';
83:
84: /* FROM clause */
85: p_where_geo VARCHAR2(1000) := '1=1 ';
86:

Line 415: p_from_time VARCHAR2(1000) := 'sys.dual ';

411: p_select_item_name VARCHAR2(1000) ;
412:
413: /* FROM clause */
414: p_from VARCHAR2(1000) := 'WIP_BIS_PROD_DEPT_YIELD_V ';
415: p_from_time VARCHAR2(1000) := 'sys.dual ';
416: p_from_geo VARCHAR2(1000) := 'sys.dual ';
417:
418: /* WHERE for target clause */
419: p_where_trgt_time VARCHAR2(1000) := 'and 1=1 ';

Line 416: p_from_geo VARCHAR2(1000) := 'sys.dual ';

412:
413: /* FROM clause */
414: p_from VARCHAR2(1000) := 'WIP_BIS_PROD_DEPT_YIELD_V ';
415: p_from_time VARCHAR2(1000) := 'sys.dual ';
416: p_from_geo VARCHAR2(1000) := 'sys.dual ';
417:
418: /* WHERE for target clause */
419: p_where_trgt_time VARCHAR2(1000) := 'and 1=1 ';
420: p_where_trgt_org VARCHAR2(1000) := 'and 1=1 ';

Line 854: from dual;

850: end if;
851:
852: select bis_excpt_wf_s.nextval
853: into l_wf_item_key
854: from dual;
855:
856: l_report_link := FND_PROFILE.value('ICX_REPORT_LINK');
857:
858: if p_report_name is not null then