[Home] [Help]
619: ,popl.pel_attribute29
620: ,popl.pel_attribute30
621: from ben_per_in_ler pil
622: ,ben_pil_elctbl_chc_popl popl
623: ,ben_cwb_person_info per
624: where pil.group_pl_id is null
625: and pil.assignment_id is null
626: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
627: and pil.per_in_ler_id = popl.per_in_ler_id
725:
726: if l_t_per_in_ler_id.count > 0 then
727:
728: forall i in l_t_per_in_ler_id.first .. l_t_per_in_ler_id.last
729: insert into ben_cwb_person_info
730: (group_per_in_ler_id
731: ,assignment_id
732: ,person_id
733: ,group_pl_id
1104: ,per_business_groups bg
1105: ,per_periods_of_service service_period
1106: ,per_pay_proposals ppp
1107: ,pay_all_payrolls_f pay
1108: ,ben_cwb_person_info pers
1109: ,(select rtg1.review_date review_date
1110: ,rtg1.performance_rating performance_rating
1111: ,rtg1.person_id person_id
1112: ,apr.appraisal_id
1326: limit g_commit_size;
1327:
1328: if l_t_group_per_in_ler_id.count > 0 then
1329: forall i in l_t_group_per_in_ler_id.first .. l_t_group_per_in_ler_id.last
1330: update ben_cwb_person_info
1331: set effective_date = l_t_effective_date(i)
1332: ,full_name = l_t_full_name(i)
1333: ,brief_name = l_t_brief_name(i)
1334: ,custom_name = l_t_custom_name(i)
1439: commit_and_log('Gather stats started');
1440: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_GROUP_HRCHY');
1441: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_GROUPS');
1442: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_RATES');
1443: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_INFO');
1444: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_PER_IN_LER');
1445: commit_and_log('Gather stats complete');
1446:
1447: