APPS.HRWSECI dependencies on PER_SCHED_COBRA_PAYMENTS_S

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