APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on BEN_CWB_PERSON_RATES

Line 460: insert into ben_cwb_person_rates

456:
457: procedure upgrade_person_rates is
458: begin
459:
460: insert into ben_cwb_person_rates
461: (person_rate_id
462: ,group_per_in_ler_id
463: ,pl_id
464: ,oipl_id

Line 493: select ben_cwb_person_rates_s.nextval

489: ,assignment_id
490: ,ws_rt_start_date
491: ,object_version_number
492: ,currency)
493: select ben_cwb_person_rates_s.nextval
494: ,pil.per_in_ler_id
495: ,popl.pl_id
496: ,nvl(epe.oipl_id, -1)
497: ,popl.pl_id

Line 529: ,ben_cwb_person_rates rate

525: ,popl.uom
526: from ben_per_in_ler pil
527: ,ben_pil_elctbl_chc_popl popl
528: ,ben_elig_per_elctbl_chc epe
529: ,ben_cwb_person_rates rate
530: ,ben_enrt_rt ws
531: ,ben_enrt_rt es
532: ,ben_enrt_rt ss
533: ,ben_enrt_rt oc

Line 1442: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_RATES');

1438: begin
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: