DBA Data[Home] [Help]

APPS.MSD_LIABILITY dependencies on DUAL

Line 850: v_sql_stmt := 'select count(1) from dual where exists (select 1 from '

846:
847: IF x_input_param_rec.planning_server_view_name is NOT NULL THEN
848:
849:
850: v_sql_stmt := 'select count(1) from dual where exists (select 1 from '
851: ||x_input_param_rec.planning_server_view_name
852: ||' where cs_name = '
853: ||''''||x_plan_name||''''||' ) ' ;
854:

Line 1911: INTO l_seq_num from dual;

1907:
1908:
1909: /* Fetch new seq number for deleted level values */
1910: SELECT msd.msd_last_refresh_number_s.nextval
1911: INTO l_seq_num from dual;
1912:
1913:
1914:
1915: For Relationship_Rec IN Relationship LOOP