select distinct PERSON_ID
,val_01 ADDUPDATE
,val_02 MEMREFNUM
,val_03 NINUMBER
,val_04 FORENAME
,val_05 SURNAME
,val_06 ADDLINE1
,val_07 ADDLINE2
,val_08 ADDLINE3
,val_09 ADDLINE4
,val_10 ADDLINE5
,val_11 POSTCODE
,val_12 DOB
,val_13 LOCALAUTHNO
,val_14 ESTBNO
,val_15 STARTDATE
,val_16 ENDDATE
,val_17 WDCONFIRM
,val_18 DAYSEXCLUDED
,val_19 FTPTINDI
,val_20 ANNUALFTSAL
,val_21 PTSALPTD
,to_number(nvl(val_22,0.00)) OVERTIMEPTD
,to_number(nvl(val_23,0.00)*0.01) ADDLCONPTD
,val_24 EMAIL
,to_number(nvl(val_25,0.00)*0.01) EERCONPTD
,to_number(nvl(val_26,0.00)*0.01) EESCONPTD
,val_27 GENDER
,nvl(val_41,0) PTSALYTD
,to_number(nvl(val_42,0.00)*0.01) ADDLCONYTD
,to_number(nvl(val_43,0.00)) OVERTIMEYTD
,to_number(nvl(val_44,0.00)*0.01) EERCONYTD
,to_number(nvl(val_45,0.00)*0.01) EESCONYTD
from ben_ext_rslt ber,
ben_ext_rslt_dtl berd,
fnd_concurrent_requests fcr1,
fnd_concurrent_requests fcr2
where fcr1.request_id = :P_REQUEST_ID
and fcr2.parent_request_id = fcr1.request_id
and fcr2.request_id = ber.REQUEST_ID
and ber.EXT_RSLT_ID = berd.EXT_RSLT_ID
and ber.BUSINESS_GROUP_ID = berd.BUSINESS_GROUP_ID
and berd.val_01 <> 'DELETE' |
