DBA Data[Home] [Help]

APPS.HR_APPLICANT_DATAUPD dependencies on HR_GENERAL

Line 103: AND paf.effective_end_date <> hr_general.end_of_time

99: FROM per_all_assignments_f paf
100: WHERE paf.application_id = p_application_id
101: AND paf.assignment_type = 'A'
102: AND paf.effective_end_date > p_termination_date
103: AND paf.effective_end_date <> hr_general.end_of_time
104: AND paf.effective_start_date =
105: (select max(effective_start_date) -- do not consider DT updates
106: from per_all_assignments_f paf2
107: where paf2.assignment_id = paf.assignment_id