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 395: l_pp_stat_cd Ben_Cwb_Person_Info.POST_PROCESS_STAT_CD%Type;

391: ,P_MGR_PER_IN_LER_ID IN NUMBER DEFAULT NULL)
392: IS
393: l_proc Varchar2(72) := g_package||'chk_processed_emp';
394: l_group_per_in_ler_id Number;
395: l_pp_stat_cd Ben_Cwb_Person_Info.POST_PROCESS_STAT_CD%Type;
396:
397: Cursor csr_PP_STAT_CD (l_ler_id IN Number)
398: IS
399: Select POST_PROCESS_STAT_CD

Line 400: From Ben_Cwb_Person_Info

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

Line 448: from ben_cwb_person_info bcpi,

444: bcpd.enrt_perd_end_dt
445: ),
446: sysdate
447: ) accesscd
448: from ben_cwb_person_info bcpi,
449: ben_cwb_person_groups bcpg,
450: ben_cwb_pl_dsgn bcpd,
451: ben_cwb_person_tasks bcpt,
452: ben_cwb_wksht_grp bcwg

Line 544: From ben_cwb_person_info per

540: Select per.assignment_id Assignment_id
541: ,per.person_id Person_id
542: ,per.business_group_id business_group_id
543: ,per.full_name Person_name
544: From ben_cwb_person_info per
545: Where per.group_per_in_ler_id = l_group_per_in_ler_id;
546:
547: cursor Csr_person_perf(l_assignment_id In Number, l_perf_revw_strt_dt In Varchar2, l_emp_interview_typ_cd In Varchar2)
548: is

Line 560: ,ben_cwb_person_info inf

556: Select dsgn.emp_interview_typ_cd
557: ,to_char(dsgn.perf_revw_strt_dt,'yyyy/mm/dd') perf_revw_strt_dt
558: ,dsgn.group_pl_id
559: From ben_cwb_pl_dsgn dsgn
560: ,ben_cwb_person_info inf
561: Where dsgn.group_oipl_id = -1
562: And dsgn.pl_id = inf.group_pl_id
563: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt
564: And inf.group_per_in_ler_id = l_group_per_in_ler_id;

Line 569: from ben_cwb_person_info

565:
566: CURSOR c_assgn_perf_rating_prcd(
567: v_group_per_in_ler_id IN NUMBER) is
568: select new_assgn_ovn, new_perf_event_id, new_perf_review_id
569: from ben_cwb_person_info
570: where group_per_in_ler_id = v_group_per_in_ler_id;
571:
572: l_person_info Csr_person_info%RowType;
573: l_pl_dsgn_info Csr_pl_dsgn_info%RowType;

Line 675: From ben_cwb_person_info per

671: Select per.assignment_id Assignment_id
672: ,per.person_id Person_id
673: ,per.business_group_id business_group_id
674: ,per.full_name Person_name
675: From ben_cwb_person_info per
676: Where per.group_per_in_ler_id = l_group_per_in_ler_id;
677:
678: Cursor Csr_pl_dsgn_info(l_group_per_in_ler_id In Number)
679: IS

Line 684: ,ben_cwb_person_info inf

680: Select dsgn.EMP_INTERVIEW_TYP_CD
681: ,to_char(dsgn.asg_updt_eff_date,'yyyy/mm/dd') asg_updt_eff_date
682: ,dsgn.group_pl_id
683: From ben_cwb_pl_dsgn dsgn
684: ,ben_cwb_person_info inf
685: Where dsgn.group_oipl_id = -1
686: And dsgn.pl_id = inf.group_pl_id
687: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt
688: And inf.group_per_in_ler_id = l_group_per_in_ler_id;

Line 730: from ben_cwb_person_info

726:
727: CURSOR c_assgn_perf_rating_prcd(
728: v_group_per_in_ler_id IN NUMBER) is
729: select new_assgn_ovn, new_perf_event_id, new_perf_review_id
730: from ben_cwb_person_info
731: where group_per_in_ler_id = v_group_per_in_ler_id;
732:
733: l_person_info Csr_person_info%RowType;
734: l_pl_dsgn_info Csr_pl_dsgn_info%RowType;

Line 1341: FROM ben_cwb_person_info

1337: custom_segment18,
1338: custom_segment19,
1339: custom_segment20,
1340: object_version_number
1341: FROM ben_cwb_person_info
1342: WHERE group_per_in_ler_id = l_group_per_in_ler_id;
1343:
1344: CURSOR csr_get_group_plan_info(l_group_per_in_ler_id IN NUMBER)
1345: IS

Line 1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;

1373: l_base_layout_code bne_layout_cols.layout_code%TYPE;
1374: l_is_read_only csr_is_read_only%RowType;
1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;

Line 1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;

1374: l_is_read_only csr_is_read_only%RowType;
1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;

Line 1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;

1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;

Line 1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;

1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;

Line 1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;

1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;

Line 1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;

1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;

Line 1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;

1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;

Line 1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;

1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;
1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;

Line 1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;

1381: l_cpi_attribute4 BEN_CWB_PERSON_INFO.cpi_attribute4%TYPE;
1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;

Line 1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;

1382: l_cpi_attribute5 BEN_CWB_PERSON_INFO.cpi_attribute5%TYPE;
1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;

Line 1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;

1383: l_cpi_attribute6 BEN_CWB_PERSON_INFO.cpi_attribute6%TYPE;
1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;

Line 1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;

1384: l_cpi_attribute7 BEN_CWB_PERSON_INFO.cpi_attribute7%TYPE;
1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;

Line 1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;

1385: l_cpi_attribute8 BEN_CWB_PERSON_INFO.cpi_attribute8%TYPE;
1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;

Line 1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;

1386: l_cpi_attribute9 BEN_CWB_PERSON_INFO.cpi_attribute9%TYPE;
1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;

Line 1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;

1387: l_cpi_attribute10 BEN_CWB_PERSON_INFO.cpi_attribute10%TYPE;
1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;

Line 1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;

1388: l_cpi_attribute11 BEN_CWB_PERSON_INFO.cpi_attribute11%TYPE;
1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;

Line 1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;

1389: l_cpi_attribute12 BEN_CWB_PERSON_INFO.cpi_attribute12%TYPE;
1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;

Line 1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;

1390: l_cpi_attribute13 BEN_CWB_PERSON_INFO.cpi_attribute13%TYPE;
1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;

Line 1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;

1391: l_cpi_attribute14 BEN_CWB_PERSON_INFO.cpi_attribute14%TYPE;
1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;

Line 1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;

1392: l_cpi_attribute15 BEN_CWB_PERSON_INFO.cpi_attribute15%TYPE;
1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;

Line 1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;

1393: l_cpi_attribute16 BEN_CWB_PERSON_INFO.cpi_attribute16%TYPE;
1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;

Line 1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;

1394: l_cpi_attribute17 BEN_CWB_PERSON_INFO.cpi_attribute17%TYPE;
1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;

Line 1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;

1395: l_cpi_attribute18 BEN_CWB_PERSON_INFO.cpi_attribute18%TYPE;
1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;

Line 1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;

1396: l_cpi_attribute19 BEN_CWB_PERSON_INFO.cpi_attribute19%TYPE;
1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;

Line 1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;

1397: l_cpi_attribute20 BEN_CWB_PERSON_INFO.cpi_attribute20%TYPE;
1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;

Line 1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;

1398: l_cpi_attribute21 BEN_CWB_PERSON_INFO.cpi_attribute21%TYPE;
1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;

Line 1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;

1399: l_cpi_attribute22 BEN_CWB_PERSON_INFO.cpi_attribute22%TYPE;
1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;

Line 1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;

1400: l_cpi_attribute23 BEN_CWB_PERSON_INFO.cpi_attribute23%TYPE;
1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;

Line 1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;

1401: l_cpi_attribute24 BEN_CWB_PERSON_INFO.cpi_attribute24%TYPE;
1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;

Line 1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;

1402: l_cpi_attribute25 BEN_CWB_PERSON_INFO.cpi_attribute25%TYPE;
1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;

Line 1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;

1403: l_cpi_attribute26 BEN_CWB_PERSON_INFO.cpi_attribute26%TYPE;
1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;

Line 1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;

1404: l_cpi_attribute27 BEN_CWB_PERSON_INFO.cpi_attribute27%TYPE;
1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;

Line 1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;

1405: l_cpi_attribute28 BEN_CWB_PERSON_INFO.cpi_attribute28%TYPE;
1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;

Line 1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;

1406: l_cpi_attribute29 BEN_CWB_PERSON_INFO.cpi_attribute29%TYPE;
1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;

Line 1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;

1407: l_cpi_attribute30 BEN_CWB_PERSON_INFO.cpi_attribute30%TYPE;
1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;

Line 1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;

1408: l_custom_segment1 BEN_CWB_PERSON_INFO.custom_segment1%TYPE;
1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;

Line 1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;

1409: l_custom_segment2 BEN_CWB_PERSON_INFO.custom_segment2%TYPE;
1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;

Line 1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;

1410: l_custom_segment3 BEN_CWB_PERSON_INFO.custom_segment3%TYPE;
1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;

Line 1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;

1411: l_custom_segment4 BEN_CWB_PERSON_INFO.custom_segment4%TYPE;
1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;

Line 1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;

1412: l_custom_segment5 BEN_CWB_PERSON_INFO.custom_segment5%TYPE;
1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;

Line 1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;

1413: l_custom_segment6 BEN_CWB_PERSON_INFO.custom_segment6%TYPE;
1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;

Line 1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;

1414: l_custom_segment7 BEN_CWB_PERSON_INFO.custom_segment7%TYPE;
1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;

Line 1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;

1415: l_custom_segment8 BEN_CWB_PERSON_INFO.custom_segment8%TYPE;
1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;

Line 1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;

1416: l_custom_segment9 BEN_CWB_PERSON_INFO.custom_segment9%TYPE;
1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;

Line 1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;

1417: l_custom_segment10 BEN_CWB_PERSON_INFO.custom_segment10%TYPE;
1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;

Line 1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;

1418: l_custom_segment11 BEN_CWB_PERSON_INFO.custom_segment11%TYPE;
1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;

Line 1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;

1419: l_custom_segment12 BEN_CWB_PERSON_INFO.custom_segment12%TYPE;
1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;

Line 1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;

1420: l_custom_segment13 BEN_CWB_PERSON_INFO.custom_segment13%TYPE;
1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;

Line 1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;

1421: l_custom_segment14 BEN_CWB_PERSON_INFO.custom_segment14%TYPE;
1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
1429: l_proc varchar2(72) := g_package||'handle_row';

Line 1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;

1422: l_custom_segment15 BEN_CWB_PERSON_INFO.custom_segment15%TYPE;
1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
1429: l_proc varchar2(72) := g_package||'handle_row';
1430: l_pl_person_rate_id Number := null;

Line 1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;

1423: l_custom_segment16 BEN_CWB_PERSON_INFO.custom_segment16%TYPE;
1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
1429: l_proc varchar2(72) := g_package||'handle_row';
1430: l_pl_person_rate_id Number := null;
1431: l_opt1_person_rate_id Number := null;

Line 1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;

1424: l_custom_segment17 BEN_CWB_PERSON_INFO.custom_segment17%TYPE;
1425: l_custom_segment18 BEN_CWB_PERSON_INFO.custom_segment18%TYPE;
1426: l_custom_segment19 BEN_CWB_PERSON_INFO.custom_segment19%TYPE;
1427: l_custom_segment20 BEN_CWB_PERSON_INFO.custom_segment20%TYPE;
1428: l_ovn BEN_CWB_PERSON_INFO.object_version_number%TYPE;
1429: l_proc varchar2(72) := g_package||'handle_row';
1430: l_pl_person_rate_id Number := null;
1431: l_opt1_person_rate_id Number := null;
1432: l_opt2_person_rate_id Number := null;

Line 2236: BEN_CWB_PERSON_INFO_API.update_person_info

2232: END IF;
2233:
2234: END LOOP;
2235:
2236: BEN_CWB_PERSON_INFO_API.update_person_info
2237: ( P_GROUP_PER_IN_LER_ID => l_GROUP_PER_IN_LER_ID
2238: ,P_CPI_ATTRIBUTE_CATEGORY => P_CPI_ATTRIBUTE_CATEGORY
2239: ,P_CPI_ATTRIBUTE1 => L_CPI_ATTRIBUTE1
2240: ,P_CPI_ATTRIBUTE2 => L_CPI_ATTRIBUTE2