APPS.PA_PAXAUMTC_XMLP_PKG dependencies on DUAL

Line 104: select '' into person_name from dual;

100: NULL;
101: end;
102:
103: ELSE
104: select '' into person_name from dual;
105: END IF;
106: c_supervisor := person_name;
107:
108:

Line 169: where_stmt := where_stmt||' union select to_date('||''''||l_dummy_date||''''|| ','||''''||l_dt_format||''''|| ') from dual';

165: l_end_date := to_char(to_date(l_end_date, l_dt_format) - 7,l_dt_format); --bug 14255823
166: end if ;
167: while to_date(l_dummy_date, l_dt_format) <= to_date(l_end_date, l_dt_format)
168: loop
169: where_stmt := where_stmt||' union select to_date('||''''||l_dummy_date||''''|| ','||''''||l_dt_format||''''|| ') from dual';
170: l_dummy_date := to_char(to_date(l_dummy_date,l_dt_format) + 7,l_dt_format); --bug 14255823
171: end loop;
172: where_stmt := where_stmt || ' minus select distinct to_date(expenditure_ending_date,'||''''||l_dt_format||''''||') from pa_expenditures where expenditure_ending_date between :date_lo and :date_hi and expenditure_class_code in (' || ''''
173: || 'PT' || '''' || ',' || '''' || 'OT' || '''' || ') order by 1' ;