BEN Communications Triggers Audit Log

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Communications Triggers Audit Log (XML)
Short Name: BENCMAUD_XML
DB package: BEN_BENCMAUD_XMLP_PKG
Select 'Name:' || ppf.full_name FULL_NAME,
          rep.person_id PERSON_ID,
          'SSN:' || ppf.national_identifier NATIONAL_IDENTIFIER,
          'Summary Action:' ||  substr(rep.TEXT,1,70) Summary_actn,
          'Person Type:' || ppt.user_person_type person_type
From  ben_reporting rep,
          ben_benefit_actions bft,
          per_people_f ppf,
          per_person_types ppt
Where  bft.request_id = :P_CONCURRENT_REQUEST_ID
and      bft.benefit_action_id = rep.benefit_action_id
and      rep.rep_typ_cd in ( 'ERRCM', 'COMMU', 'NOCOMMU', 'FATAL')
and      rep.person_id = ppf.person_id
and      ppf.person_type_id = ppt.person_type_id 
and      ppt.business_group_id = ppf.business_group_id
and      bft.process_date between 
               ppf.effective_start_date and ppf.effective_end_date 
order    by ppf.national_identifier asc
Parameter Name SQL text Validation
Concurrent Request ID
 
LOV Oracle