APPS.PQH_PA_WHATIF_PROCESS dependencies on DUAL

Line 3743: FROM sys.dual;

3739: ) IS
3740:
3741: CURSOR csr_sequence_val IS
3742: SELECT pqh_pa_whatif_results_s.nextval
3743: FROM sys.dual;
3744: --
3745: l_proc VARCHAR2(72);
3746:
3747: BEGIN

Line 4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;

4203: -- Dump data from PL / SQL table to pqh_pa_watif_results;
4204: IF l_conflict_life_events THEN
4205: -- Conflicting LE's are there
4206: BEGIN
4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
4211: hr_utility.set_message_token('ROUTINE', l_proc);