APPS.PER_COBRA_ECI dependencies on PER_SCHED_COBRA_PAYMENTS_S

Line 1114: SELECT per_sched_cobra_payments_s.nextval

1110: --
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

Line 2511: FROM per_sched_cobra_payments scp

2507: -- declare cursor
2508: --
2509: CURSOR due_date IS
2510: SELECT 'Y'
2511: FROM per_sched_cobra_payments scp
2512: WHERE scp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2513: AND ( scp.scheduled_cobra_payment_id <> p_scheduled_cobra_payment_id
2514: OR p_scheduled_cobra_payment_id IS NULL
2515: )

Line 2577: SELECT per_sched_cobra_payments_s.nextval

2573: --
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: --

Line 2667: FROM per_sched_cobra_payments scp

2663: -- define cursor
2664: --
2665: CURSOR lock_scp IS
2666: SELECT 'lock payment_schedules'
2667: FROM per_sched_cobra_payments scp
2668: WHERE scp.business_group_id + 0 = p_business_group_id
2669: AND scp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2670: FOR UPDATE OF scp.scheduled_cobra_payment_id;
2671: --

Line 3171: UPDATE per_sched_cobra_payments scp

3167: PROCEDURE hr_cobra_correct_scp( p_cobra_coverage_enrollment_id NUMBER,
3168: p_session_date DATE ) IS
3169: BEGIN
3170: --
3171: UPDATE per_sched_cobra_payments scp
3172: SET amount_due =
3173: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))
3174: FROM per_cobra_coverage_benefits_f ccb
3175: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id