PER COBRA Expiration Letter

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: COBRA Expiration Letter
Application: Human Resources
Source: COBRA Expiration Letter (XML)
Short Name: PERRPCNE_XML
DB package: PER_PERUSCNE_XMLP_PKG
Run PER COBRA Expiration Letter and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT
       org.name                                             org_name,
       cce.cobra_coverage_enrollment_id                    enrol_id,
       DECODE(cce.contact_relationship_id,null,:p_person_id,
                                   pcs.contact_person_id)   per_id
FROM
       per_organization_units                               org,
       per_cobra_cov_enrollments                            cce,
       per_contact_relationships                                         pcs,
       per_assignments_f                                    asg,
       per_people_f                                         per
WHERE
       org.organization_id              = asg.organization_id
AND
       cce.contact_relationship_id     = pcs.contact_relationship_id (+) AND
       cce.assignment_id               = asg.assignment_id               AND
       cce.qualifying_date             =
        ( SELECT NVL(:p_qual_date,MAX(pc2.qualifying_date))
           FROM  per_cobra_cov_enrollments pc2
           WHERE pc2.assignment_id   = asg.assignment_id
            and pc2.qualifying_date <= NVL(:p_qual_date,:lp_session_date)
        )
AND
       asg.person_id                    = per.person_id
AND
       cce.qualifying_date BETWEEN asg.effective_start_date AND
                               asg.effective_end_date
AND
       per.person_id                    = :p_person_id AND
      :lp_session_date BETWEEN per.effective_start_date AND
      per.effective_end_date
Parameter Name SQL text Validation
Employee Name 
 
 LOV Oracle
Qualifying Date 
 
 Date
Download
Related Blitz Reports
PER COBRA Grace Period Expiration Letter PER COBRA Payments PER COBRA Coverage PER COBRA Notification Letter BEN COBRA Benefit Initial Information CSD Depot Repair Traveler PER Invalid Address BEN COBRA Benefit Notification Letter OTA Learner Sign-In Sheet
Blitz Report™

Blitz Report™ provides multiple benefits: