DBA Data[Home] [Help]

APPS.HR_GBBAL dependencies on PER_PEOPLE_F

Line 524: from per_people_f p, /* should this be all ? */

520: BEGIN
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