APPS.PER_COBRA_ECI dependencies on PER_SCHED_COBRA_PAYMENTS

Line 1082: -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS

1078: -- Name hr_cobra_ins_schedule
1079: --
1080: -- Purpose
1081: --
1082: -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS
1083: --
1084: -- Arguments
1085: --
1086: -- p_business_group_id NUMBER

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 1120: FROM per_sched_cobra_payments

1116:
1117: -- Added to check existing scheduled payments Bug#4599753
1118: CURSOR check_scp IS
1119: SELECT NVL(COUNT(*),0)
1120: FROM per_sched_cobra_payments
1121: WHERE cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1122: AND business_group_id = p_business_group_id;
1123:
1124: ln_rec_count number;

Line 1150: INSERT INTO per_sched_cobra_payments (

1146: CLOSE get_scp_id;
1147: --
1148: -- insert payment schedules
1149: --
1150: INSERT INTO per_sched_cobra_payments (
1151: scheduled_cobra_payment_id,
1152: business_group_id,
1153: cobra_coverage_enrollment_id,
1154: amount_due,

Line 1249: -- updates grace_due_date in per_sched_cobra_payments table if the

1245: -- Name correct_cobra_scp_graceperiod
1246: --
1247: -- Purpose
1248: --
1249: -- updates grace_due_date in per_sched_cobra_payments table if the
1250: -- user has updated the cobra grace period.
1251: --
1252: -- Arguments
1253: --

Line 1268: update per_sched_cobra_payments

1264: p_session_date DATE,
1265: p_new_grace_days NUMBER) IS
1266: BEGIN
1267: --
1268: update per_sched_cobra_payments
1269: set grace_due_date = date_due + p_new_grace_days
1270: where COBRA_COVERAGE_ENROLLMENT_ID = p_cobra_coverage_enrollment_id
1271: and grace_due_date - date_due <> p_new_grace_days
1272: and amount_received is null

Line 1348: from per_sched_cobra_payments

1344: -- Bug#4599753 new cursor
1345: cursor c_get_old_scp_graceperiod(cp_cov_enrollment_id number,
1346: cp_session_date date) is
1347: select SCHEDULED_COBRA_PAYMENT_ID,grace_due_date - date_due
1348: from per_sched_cobra_payments
1349: where COBRA_COVERAGE_ENROLLMENT_ID = cp_cov_enrollment_id
1350: and amount_received is null
1351: and date_received is null
1352: and date_due >= cp_session_date;

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 3166: UPDATE per_sched_cobra_payments scp

3162: PROCEDURE hr_cobra_correct_scp( p_cobra_coverage_enrollment_id NUMBER,
3163: p_session_date DATE ) IS
3164: BEGIN
3165: --
3166: UPDATE per_sched_cobra_payments scp
3167: SET amount_due =
3168: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))
3169: FROM per_cobra_coverage_benefits_f ccb
3170: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id