DBA Data[Home] [Help]

APPS.HR_GBBAL dependencies on PER_ASSIGNMENTS_F

Line 525: per_assignments_f ass

521: select nvl(min(P.effective_start_date)
522: ,fnd_date.canonical_to_date('4712/12/31'))
523: into l_event_from_date
524: from per_people_f p, /* should this be all ? */
525: per_assignments_f ass
526: where p.per_information2 = 'Y'
527: and ASS.person_id = P.person_id
528: and P.effective_start_date <= p_end_date
529: and p.effective_end_date >= p_start_date