APPS.PY_AUDIT_REP_PKG dependencies on DUAL

Line 129: from dual

125: -- cursor to check that audit table exists
126: --
127: cursor csr_chk_tabname(p_table_name varchar2, p_oracle_schema varchar2) is
128: select 1
129: from dual
130: where exists (
131: select 1
132: from all_tables tab
133: where tab.table_name = p_table_name

Line 362: 'l_audit from dual;' ||

358: 'end ins;' ||
359: --
360: 'begin ' ||
361: 'select hr_audits_s.nextval into ' ||
362: 'l_audit from dual;' ||
363: 'open dt_curs;' ||
364: 'loop ' ||
365: 'fetch dt_curs into l_trans,' ||
366: 'l_tstamp,' ||

Line 1083: 'l_audit from dual;' ||

1079: -- NDT TEXT 15
1080: --
1081: ndt_text15:= 'begin ' ||
1082: 'select hr_audits_s.nextval into ' ||
1083: 'l_audit from dual;' ||
1084: 'open ndt_curs;' ||
1085: 'loop ' ||
1086: 'fetch ndt_curs into l_tstamp,' ||
1087: 'l_type,' ||