APPS.BEN_CWB_BACK_OUT_CONC dependencies on PER_ALL_PEOPLE_F

Line 637: l_per_rec per_all_people_f%rowtype;

633: l_threads number(15);
634: l_effective_date date;
635: l_ocrd_date date;
636: l_commit number;
637: l_per_rec per_all_people_f%rowtype;
638: l_dummy2 number;
639: -- l_per_dummy_rec per_all_people_f%rowtype;
640:
641: -- Cursors declaration

Line 639: -- l_per_dummy_rec per_all_people_f%rowtype;

635: l_ocrd_date date;
636: l_commit number;
637: l_per_rec per_all_people_f%rowtype;
638: l_dummy2 number;
639: -- l_per_dummy_rec per_all_people_f%rowtype;
640:
641: -- Cursors declaration
642: --
643: Cursor c_range_thread is

Line 713: from per_all_people_f ppf

709: l_latest_ler_cwb c_latest_ler_cwb%rowtype;
710: --
711: cursor c_person is
712: select ppf.*
713: from per_all_people_f ppf
714: where ppf.person_id = l_person_id
715: and nvl(l_effective_date,trunc(sysdate))
716: between ppf.effective_start_date
717: and ppf.effective_end_date;

Line 721: from per_all_people_f ppf

717: and ppf.effective_end_date;
718: --
719: cursor c_person_last is
720: select ppf.*
721: from per_all_people_f ppf
722: where ppf.person_id = l_person_id
723: order by effective_start_date desc;
724: --
725: Begin

Line 1126: from per_all_people_f ppf

1122:
1123:
1124: cursor c_person is
1125: select distinct ppf.person_id, ppf.business_group_id
1126: from per_all_people_f ppf
1127: where -- l_effective_date between ppf.effective_start_date and ppf.effective_end_date and
1128: exists (select null
1129: from ben_per_in_ler pil
1130: , ben_ler_f ler

Line 1338: -- from per_all_people_f where person_id = l_person_id

1334: -- BEN_91698_NO_ASSIGNMENT_FND then try running the formula again
1335: -- with different effective date.
1336: -- get the effective date from person record and use it.
1337: -- select effective_start_date, effective_end_date
1338: -- from per_all_people_f where person_id = l_person_id
1339: -- order by effective_start_date desc;
1340: --
1341: Ben_batch_utils.write(p_text =>
1342: '<< Person id : '||to_char(l_person_id)||' failed.'||