DBA Data[Home] [Help]

APPS.HR_PERSON_API dependencies on HR_GENERAL

Line 217: nvl(pds.date_start, hr_general.start_of_time)

213: select pds.period_of_service_id, pds.object_version_number, pds.adjusted_svc_date
214: from per_periods_of_service pds
215: where pds.person_id = p_person_id
216: and l_effective_date between
217: nvl(pds.date_start, hr_general.start_of_time)
218: and nvl(pds.actual_termination_date,hr_general.end_of_time);
219: --
220: cursor csr_phones is
221: select phone_number,

Line 218: and nvl(pds.actual_termination_date,hr_general.end_of_time);

214: from per_periods_of_service pds
215: where pds.person_id = p_person_id
216: and l_effective_date between
217: nvl(pds.date_start, hr_general.start_of_time)
218: and nvl(pds.actual_termination_date,hr_general.end_of_time);
219: --
220: cursor csr_phones is
221: select phone_number,
222: phone_id,

Line 673: if not hr_general2.is_person_type

669: end if;
670: --
671: -- Check if the new person type is valid for current person type
672:
673: if not hr_general2.is_person_type
674: (p_person_id,l_current_system_person_type,l_effective_date) then
675: fnd_message.set_name('PER','PER_289603_CWK_INV_PERSON_TYPE');
676: fnd_message.raise_error;
677: end if;