APPS.HR_PROCESS_CONTACT_SS dependencies on PER_PEOPLE_F

Line 6798: get Employee_DOB from per_people_f

6794:
6795: 1. Get emplyee record start date
6796:
6797: if employee id is available, then
6798: get Employee_DOB from per_people_f
6799: else
6800: get Employee_DOB from transaction_step
6801:
6802: 1. if l_main_per_date_of_birth is not null and l_main_per_date_of_birth > p_date_start then

Line 6826: get employee_effective_start_date from per_people_f

6822:
6823: 1. Get emplyee record start date
6824:
6825: If employee id is available, then
6826: get employee_effective_start_date from per_people_f
6827: Else
6828: get the employee_effective_start_date from trx
6829:
6830: 2. Set p_date_start to last of

Line 6854: from per_people_f p

6850:
6851: if l_person_id is not null then
6852: select min(p.date_of_birth) , min(p.effective_start_date)
6853: into l_main_per_date_of_birth , l_main_per_eff_start_date
6854: from per_people_f p
6855: where p.person_id = l_person_id;
6856: else
6857: begin
6858: select nvl(max(hats1.transaction_step_id),0)

Line 16743: get Employee_DOB from per_people_f

16739:
16740: 1. Get emplyee record start date
16741:
16742: if employee id is available, then
16743: get Employee_DOB from per_people_f
16744: else
16745: get Employee_DOB from transaction_step
16746:
16747: 1. if l_main_per_date_of_birth is not null and l_main_per_date_of_birth > p_date_start then

Line 16776: from per_people_f p

16772: if p_person_id is not null then
16773: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 10);
16774: select min(p.date_of_birth) , min(p.effective_start_date)
16775: into l_main_per_date_of_birth , l_main_per_eff_start_date
16776: from per_people_f p
16777: where p.person_id = p_person_id;
16778: else
16779: begin
16780: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 15);