APPS.PER_COBRA_ECI dependencies on DUAL

Line 1115: FROM dual;

1111: -- declare cursor for scp_id
1112: --
1113: CURSOR get_scp_id IS
1114: SELECT per_sched_cobra_payments_s.nextval
1115: FROM dual;
1116:
1117: -- Added to check existing scheduled payments Bug#4599753
1118: CURSOR check_scp IS
1119: SELECT NVL(COUNT(*),0)

Line 1611: FROM dual;

1607: and ccbf.business_group_id = p_business_group_id);
1608: --
1609: CURSOR get_benefit_id IS
1610: SELECT per_cobra_coverage_benefits_s.nextval
1611: FROM dual;
1612:
1613: BEGIN
1614:
1615: hr_utility.set_location('Entering...' || l_package, 10);

Line 2578: FROM sys.dual;

2574: -- declare cursor
2575: --
2576: CURSOR scp_id IS
2577: SELECT per_sched_cobra_payments_s.nextval
2578: FROM sys.dual;
2579:
2580: l_package VARCHAR2(70) := g_package || 'hr_cobra_do_scp_insert';
2581: --
2582: BEGIN

Line 2959: FROM dual

2955: -- AND coverage
2956: --
2957: CURSOR chk_ee_exists IS
2958: SELECT 'Y'
2959: FROM dual
2960: WHERE EXISTS
2961: ( SELECT 'x'
2962: FROM pay_element_entry_values eev_cov,
2963: pay_input_values iv_cov,

Line 3518: from dual;

3514: p_effective_end_date => p_effective_end_date);
3515: --
3516: select per_cobra_dependents_s.nextval
3517: into p_cobra_dependent_id
3518: from dual;
3519: --
3520: p_object_version_number := 1;
3521: --
3522: insert into per_cobra_dependents_f