APPS.HRWSECI dependencies on PER_SCHED_COBRA_PAYMENTS

Line 1018: -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS

1014: -- Name hr_cobra_ins_schedule
1015: --
1016: -- Purpose
1017: --
1018: -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS
1019: --
1020: -- Arguments
1021: --
1022: -- p_business_group_id NUMBER

Line 1050: SELECT per_sched_cobra_payments_s.nextval

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

Line 1067: INSERT INTO per_sched_cobra_payments (

1063: CLOSE get_scp_id;
1064: --
1065: -- insert payment schedules
1066: --
1067: INSERT INTO per_sched_cobra_payments (
1068: scheduled_cobra_payment_id,
1069: business_group_id,
1070: cobra_coverage_enrollment_id,
1071: amount_due,

Line 1892: FROM per_sched_cobra_payments scp

1888: -- declare cursor
1889: --
1890: CURSOR due_date IS
1891: SELECT 'Y'
1892: FROM per_sched_cobra_payments scp
1893: WHERE scp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1894: AND ( scp.scheduled_cobra_payment_id <> p_scheduled_cobra_payment_id
1895: OR p_scheduled_cobra_payment_id IS NULL
1896: )

Line 1956: SELECT per_sched_cobra_payments_s.nextval

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

Line 2046: FROM per_sched_cobra_payments scp

2042: -- define cursor
2043: --
2044: CURSOR lock_scp IS
2045: SELECT 'lock payment_schedules'
2046: FROM per_sched_cobra_payments scp
2047: WHERE scp.business_group_id + 0 = p_business_group_id
2048: AND scp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2049: FOR UPDATE OF scp.scheduled_cobra_payment_id;
2050: --

Line 2537: UPDATE per_sched_cobra_payments scp

2533: PROCEDURE hr_cobra_correct_scp( p_cobra_coverage_enrollment_id NUMBER,
2534: p_session_date DATE ) IS
2535: BEGIN
2536: --
2537: UPDATE per_sched_cobra_payments scp
2538: SET amount_due =
2539: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))
2540: FROM per_cobra_coverage_benefits_f ccb
2541: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id