DBA Data[Home] [Help]

APPS.PAY_US_VERTEX_INTERFACE dependencies on DUAL

Line 164: from dual

160: hr_utility.trace('1100 -> Start payroll_run_exist ');
161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');
162: select 'Y'
163: into l_payroll_exist
164: from dual
165: where exists( select 1
166: from PAY_PAYROLL_ACTIONS PPA
167: where PPA.action_type IN ('R','Q')
168: and PPA.action_status = 'C'

Line 290: from DUAL;

286: --{
287: select decode(p_lookup_code,
288: 'STANDARD', 'In Use','Not in Use')
289: into l_ret_value
290: from DUAL;
291: hr_utility.trace('1215 -> Current Tax Interface element is VERTEX');
292: hr_utility.trace('1220 -> Return Value '||l_ret_value);
293: return l_ret_value;
294: --}

Line 304: from DUAL;

300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');
301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')
303: into l_ret_value
304: from DUAL;
305: hr_utility.trace('1240 -> Return Value '||l_ret_value);
306: return l_ret_value;
307:
308: --}