APPS.HR_PROCESS_CONTACT_SS dependencies on PER_PEOPLE_F

Line 6867: get Employee_DOB from per_people_f

6863:
6864: 1. Get emplyee record start date
6865:
6866: if employee id is available, then
6867: get Employee_DOB from per_people_f
6868: else
6869: get Employee_DOB from transaction_step
6870:
6871: 1. if l_main_per_date_of_birth is not null and l_main_per_date_of_birth > p_date_start then

Line 6895: get employee_effective_start_date from per_people_f

6891:
6892: 1. Get emplyee record start date
6893:
6894: If employee id is available, then
6895: get employee_effective_start_date from per_people_f
6896: Else
6897: get the employee_effective_start_date from trx
6898:
6899: 2. Set p_date_start to last of

Line 6923: from per_people_f p

6919:
6920: if l_person_id is not null then
6921: select min(p.date_of_birth) , min(p.effective_start_date)
6922: into l_main_per_date_of_birth , l_main_per_eff_start_date
6923: from per_people_f p
6924: where p.person_id = l_person_id;
6925: else
6926: begin
6927: select nvl(max(hats1.transaction_step_id),0)

Line 16937: get Employee_DOB from per_people_f

16933:
16934: 1. Get emplyee record start date
16935:
16936: if employee id is available, then
16937: get Employee_DOB from per_people_f
16938: else
16939: get Employee_DOB from transaction_step
16940:
16941: 1. if l_main_per_date_of_birth is not null and l_main_per_date_of_birth > p_date_start then

Line 16970: from per_people_f p

16966: if p_person_id is not null then
16967: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 10);
16968: select min(p.date_of_birth) , min(p.effective_start_date)
16969: into l_main_per_date_of_birth , l_main_per_eff_start_date
16970: from per_people_f p
16971: where p.person_id = p_person_id;
16972: else
16973: begin
16974: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 15);