DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on HR_GENERAL

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

1630: --
1631: if (((p_current_employee_flag = 'Y')
1632: and (p_hire_date <> p_s_hire_date)
1633: and (p_system_person_type = p_s_system_person_type)))
1634: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
1635: <> nvl(p_s_adjusted_svc_date,
1636: hr_general.end_of_time)
1637: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1638: --

Line 1636: hr_general.end_of_time)

1632: and (p_hire_date <> p_s_hire_date)
1633: and (p_system_person_type = p_s_system_person_type)))
1634: or (nvl(p_adjusted_svc_date,hr_general.end_of_time) -- #1573563
1635: <> nvl(p_s_adjusted_svc_date,
1636: hr_general.end_of_time)
1637: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1638: --
1639: -- Verify person has been employee before modifying the POS
1640: --

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

1637: -- and (p_s_system_person_type not in ('EX_EMP','EX_EMP_APL')) -- #2060744
1638: --
1639: -- Verify person has been employee before modifying the POS
1640: --
1641: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
1642: ) then
1643: --
1644: -- Update the period of service for the employee
1645: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);