APPS.HRWSECI dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 820: -- Creates row in PER_COBRA_COVERAGE_BENEFITS

816: -- Name hr_cobra_ins_benefits;
817: --
818: -- Purpose
819: --
820: -- Creates row in PER_COBRA_COVERAGE_BENEFITS
821: --
822: -- Arguments
823: --
824: -- p_cobra_coverage_enrollment_id

Line 851: INSERT INTO per_cobra_coverage_benefits_f (

847: --
848: --
849: -- insert benefits
850: --
851: INSERT INTO per_cobra_coverage_benefits_f (
852: cobra_coverage_benefit_id,
853: cobra_coverage_enrollment_id,
854: effective_start_date,
855: effective_end_date,

Line 867: per_cobra_coverage_benefits_s.nextval,

863: creation_date,
864: created_by,
865: last_update_login)
866: SELECT
867: per_cobra_coverage_benefits_s.nextval,
868: p_cobra_coverage_enrollment_id,
869: p_qualifying_date,
870: to_date('31-12-4712', 'DD-MM-YYYY'),
871: et.element_type_id,

Line 990: FROM per_cobra_coverage_benefits ccb

986: -- SELECT TO_CHAR(sum(TO_NUMBER(ccb.coverage_amount)), 999999999990.99)
987: --
988: CURSOR amount_charged IS
989: SELECT fnd_number.number_to_canonical(SUM(fnd_number.canonical_to_number(ccb.coverage_amount)))
990: FROM per_cobra_coverage_benefits ccb
991: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
992: AND ccb.accept_reject_flag = 'ACC';
993: --
994: BEGIN

Line 1139: FROM per_cobra_coverage_benefits_f ccb

1135: l_user_id,
1136: l_login_id,
1137: l_user_id,
1138: TRUNC(sysdate)
1139: FROM per_cobra_coverage_benefits_f ccb
1140: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1141: AND ADD_MONTHS(p_first_payment_due_date, l_count) BETWEEN
1142: ccb.effective_start_date AND ccb.effective_end_date
1143: AND ccb.accept_reject_flag = 'ACC';

Line 2253: FROM per_cobra_coverage_benefits_f ccb

2249: -- declare cursor
2250: --
2251: CURSOR rej_to_acc Is
2252: SELECT 'Y'
2253: FROM per_cobra_coverage_benefits_f ccb
2254: WHERE ccb.rowid = p_rowid
2255: AND ccb.accept_reject_flag = 'REJ';
2256: --
2257: BEGIN

Line 2540: FROM per_cobra_coverage_benefits_f ccb

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
2542: AND scp.date_due BETWEEN
2543: ccb.effective_start_date AND ccb.effective_end_date
2544: AND ccb.accept_reject_flag = 'ACC' )