eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_INFO

Line 392: l_pp_stat_cd Ben_Cwb_Person_Info.POST_PROCESS_STAT_CD%Type;

388: ,P_OPT4_PERSON_RATE_ID IN NUMBER Default Null)
389: IS
390: l_proc Varchar2(72) := g_package||'chk_processed_emp';
391: l_group_per_in_ler_id Number;
392: l_pp_stat_cd Ben_Cwb_Person_Info.POST_PROCESS_STAT_CD%Type;
393:
394: Cursor csr_PP_STAT_CD (l_ler_id IN Number)
395: IS
396: Select POST_PROCESS_STAT_CD

Line 397: From Ben_Cwb_Person_Info

393:
394: Cursor csr_PP_STAT_CD (l_ler_id IN Number)
395: IS
396: Select POST_PROCESS_STAT_CD
397: From Ben_Cwb_Person_Info
398: Where Group_Per_In_Ler_Id = l_ler_id;
399:
400: -- added by kmg for fixing bug#6830922
401: CURSOR csr_ws_stat_cd (l_ler_id IN NUMBER) IS

Line 468: From ben_cwb_person_info per

464: Select per.assignment_id Assignment_id
465: ,per.person_id Person_id
466: ,per.business_group_id business_group_id
467: ,per.full_name Person_name
468: From ben_cwb_person_info per
469: Where per.group_per_in_ler_id = l_group_per_in_ler_id;
470:
471:
472:

Line 479: ,ben_cwb_person_info inf

475: Select dsgn.EMP_INTERVIEW_TYP_CD
476: ,dsgn.perf_revw_strt_dt
477: ,dsgn.group_pl_id
478: From ben_cwb_pl_dsgn dsgn
479: ,ben_cwb_person_info inf
480: Where dsgn.group_oipl_id = -1
481: And dsgn.pl_id = inf.group_pl_id
482: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt
483: And inf.group_per_in_ler_id = l_group_per_in_ler_id;

Line 882: FROM ben_cwb_person_info

878: custom_segment18,
879: custom_segment19,
880: custom_segment20,
881: object_version_number
882: FROM ben_cwb_person_info
883: WHERE group_per_in_ler_id = l_group_per_in_ler_id;
884:
885: CURSOR csr_get_group_plan_info(l_group_per_in_ler_id IN NUMBER)
886: IS

Line 906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;

902:
903: l_is_read_only csr_is_read_only%RowType;
904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;

Line 907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;

903: l_is_read_only csr_is_read_only%RowType;
904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;

Line 908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;

904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;

Line 909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;

905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;

Line 910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;

906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;

Line 911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;

907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;

Line 912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;

908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;

Line 913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;

909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;

Line 914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;

910: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;

Line 915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;

911: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;

Line 916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;

912: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;

Line 917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;

913: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;

Line 918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;

914: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;

Line 919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;

915: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;

Line 920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;

916: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;

Line 921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;

917: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;

Line 922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;

918: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;

Line 923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;

919: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;

Line 924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;

920: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;

Line 925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;

921: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;

Line 926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;

922: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;

Line 927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;

923: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;

Line 928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;

924: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;

Line 929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;

925: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;

Line 930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;

926: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;

Line 931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;

927: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;

Line 932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;

928: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;

Line 933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;

929: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;

Line 934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;

930: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;

Line 935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;

931: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;

Line 936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;

932: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;

Line 937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;

933: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;

Line 938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;

934: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;

Line 939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;

935: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;

Line 940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;

936: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;

Line 941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;

937: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;

Line 942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;

938: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;

Line 943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;

939: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;

Line 944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;

940: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;

Line 945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;

941: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;

Line 946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;

942: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;

Line 947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;

943: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;

Line 948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;

944: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;

Line 949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;

945: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;

Line 950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;

946: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;

Line 951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;

947: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;

Line 952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;

948: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;

Line 953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;

949: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;

Line 954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;

950: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
958: l_proc varchar2(72) := g_package||'handle_row';

Line 955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;

951: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
958: l_proc varchar2(72) := g_package||'handle_row';
959: l_pl_person_rate_id Number := null;

Line 956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;

952: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
958: l_proc varchar2(72) := g_package||'handle_row';
959: l_pl_person_rate_id Number := null;
960: l_opt1_person_rate_id Number := null;

Line 957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;

953: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
954: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
955: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
956: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
957: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
958: l_proc varchar2(72) := g_package||'handle_row';
959: l_pl_person_rate_id Number := null;
960: l_opt1_person_rate_id Number := null;
961: l_opt2_person_rate_id Number := null;

Line 1639: BEN_CWB_PERSON_INFO_API.update_person_info

1635: END IF;
1636:
1637: END LOOP;
1638:
1639: BEN_CWB_PERSON_INFO_API.update_person_info
1640: ( P_GROUP_PER_IN_LER_ID => l_GROUP_PER_IN_LER_ID
1641: ,P_CPI_ATTRIBUTE_CATEGORY => P_CPI_ATTRIBUTE_CATEGORY
1642: ,P_CPI_ATTRIBUTE1 => L_CPI_ATTRIBUTE1
1643: ,P_CPI_ATTRIBUTE2 => L_CPI_ATTRIBUTE2