APPS.PA_PAXAUMTC_XMLP_PKG dependencies on DUAL

Line 91: select '' into person_name from dual;

87: or (effective_start_date > sysdate))
88: and (employee_number IS NOT NULL or npw_number IS NOT NULL);
89:
90: ELSE
91: select '' into person_name from dual;
92: END IF;
93: c_supervisor := person_name;
94:
95:

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

153: l_end_date := to_date(l_end_date, l_dt_format) - 7;
154: end if ;
155: while to_date(l_dummy_date, l_dt_format) <= to_date(l_end_date, l_dt_format)
156: loop
157: where_stmt := where_stmt||' union select to_date('||''''||l_dummy_date||''''|| ','||''''||l_dt_format||''''|| ') from dual';
158: l_dummy_date := to_date(l_dummy_date,l_dt_format) + 7;
159: end loop;
160: 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 (' || ''''
161: || 'PT' || '''' || ',' || '''' || 'OT' || '''' || ') order by 1' ;