DBA Data[Home] [Help]

APPS.HRWSECI dependencies on DUAL

Line 1051: FROM dual;

1047: -- declare cursor for scp_id
1048: --
1049: CURSOR get_scp_id IS
1050: SELECT per_sched_cobra_payments_s.nextval
1051: FROM dual;
1052: --
1053: BEGIN
1054: --
1055: hr_utility.set_location('hrwseci.hr_cobra_ins_schedule', 0);

Line 1957: FROM sys.dual;

1953: -- declare cursor
1954: --
1955: CURSOR scp_id IS
1956: SELECT per_sched_cobra_payments_s.nextval
1957: FROM sys.dual;
1958: --
1959: BEGIN
1960: --
1961: -- hr_utility.trace_on;

Line 2336: FROM dual

2332: -- AND coverage
2333: --
2334: CURSOR chk_ee_exists IS
2335: SELECT 'Y'
2336: FROM dual
2337: WHERE EXISTS
2338: ( SELECT 'x'
2339: FROM pay_element_entry_values eev_cov,
2340: pay_input_values iv_cov,

Line 2883: from dual;

2879: p_effective_end_date => p_effective_end_date);
2880: --
2881: select per_cobra_dependents_s.nextval
2882: into p_cobra_dependent_id
2883: from dual;
2884: --
2885: p_object_version_number := 1;
2886: --
2887: insert into per_cobra_dependents_f