APPS.HR_LEG_INSTALLATION_PKG dependencies on DUAL

Line 60: from dual

56: p_creation_date,
57: p_last_update_login,
58: p_last_update_date,
59: p_last_updated_by
60: from dual
61: WHERE not exists (select 1 from hr_legislation_installations
62: where application_short_name=p_application_short_name
63: and nvl(p_legislation_code,'x')=nvl(legislation_code,'x'));
64: end;

Line 140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';

136: from hr_legislation_installations
137: where application_short_name=p_product
138: and nvl(p_legislation,'x')=nvl(legislation_code,'x');
139:
140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';
141: sql_curs := dbms_sql.open_cursor;
142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);