PER COBRA Grace Period Expiration Letter

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: COBRA Grace Period Expiration Letter
Application: Human Resources
Source: COBRA Grace Period Expiration Letter (XML)
Short Name: PERRPCPE_XML
DB package: PER_PERUSCPE_XMLP_PKG
Run PER COBRA Grace Period Expiration Letter and other Oracle EBS reports with Blitz Report™ on our demo environment
select org.name                                             org_name,
       pcce.cobra_coverage_enrollment_id                    enrol_id,
       decode(pcce.CONTACT_RELATIONSHIP_ID,null,:p_person_id,
                                   pcs.contact_person_id)   per_id
from   per_cobra_cov_enrollments                            pcce,
       per_organization_units                               org,
       per_contact_relationships                                         pcs,
       per_assignments_f                                    asg,
       per_people_f                                         per
where  pcce.CONTACT_RELATIONSHIP_ID                  = pcs.CONTACT_RELATIONSHIP_ID (+)
and    pcce.assignment_id               = asg.assignment_id
and    pcce.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    pcce.qualifying_date  between asg.effective_start_date and
                                asg.effective_end_date
and    org.organization_id              = asg.organization_id
and    org.business_group_id    = :p_business_group_id
and    per.person_id                    = :p_person_id
and    :P_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 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: