DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on HR_GENERAL

Line 1911: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563

1907: --
1908: if (((p_current_employee_flag = 'Y')
1909: and (p_hire_date <> p_s_hire_date)
1910: and (p_system_person_type = p_s_system_person_type)))
1911: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
1912: <> nvl(p_s_adjusted_svc_date,
1913: hr_general.end_of_time)
1914: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1915: --

Line 1913: hr_general.end_of_time)

1909: and (p_hire_date <> p_s_hire_date)
1910: and (p_system_person_type = p_s_system_person_type)))
1911: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
1912: <> nvl(p_s_adjusted_svc_date,
1913: hr_general.end_of_time)
1914: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1915: --
1916: -- Verify person has been employee before modifying the POS
1917: --

Line 1918: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146

1914: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1915: --
1916: -- Verify person has been employee before modifying the POS
1917: --
1918: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
1919: ) then
1920: --
1921: -- Update the period of service for the employee
1922: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',290);

Line 3916: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563

3912: --
3913: if (((p_current_employee_flag = 'Y')
3914: and (p_hire_date <> p_s_hire_date)
3915: and (p_system_person_type = p_s_system_person_type)))
3916: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
3917: <> nvl(p_s_adjusted_svc_date,
3918: hr_general.end_of_time)
3919: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
3920: --

Line 3918: hr_general.end_of_time)

3914: and (p_hire_date <> p_s_hire_date)
3915: and (p_system_person_type = p_s_system_person_type)))
3916: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
3917: <> nvl(p_s_adjusted_svc_date,
3918: hr_general.end_of_time)
3919: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
3920: --
3921: -- Verify person has been employee before modifying the POS
3922: --

Line 3923: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146

3919: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
3920: --
3921: -- Verify person has been employee before modifying the POS
3922: --
3923: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
3924: ) then
3925: --
3926: -- Update the period of service for the employee
3927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);