DBA Data[Home] [Help]

APPS.PAY_US_LOC_CHANGE dependencies on DUAL

Line 29: from dual;

25: program => 'LOCCHNREP');
26:
27: select userenv('sessionid')
28: into l_session_id
29: from dual;
30:
31: IF(l_rep_req_id = 0) THEN
32: hr_utility.trace(' Error While Location change Report' );
33: hr_utility.raise_error;

Line 196: from dual;

192: hr_utility.trace('Entering :' || l_proc_name);
193:
194: select userenv('sessionid')
195: into l_session_id
196: from dual;
197:
198: INSERT
199: INTO pay_us_rpt_totals
200: (