DBA Data[Home] [Help]

APPS.PY_ZA_BAL dependencies on PER_ASSIGNMENTS_F

Line 455: per_assignments_f ass

451: select nvl(min(P.effective_start_date)
452: ,to_date('31-12-4712','dd-mm-yyyy'))
453: into l_event_from_date
454: from per_people_f p, /* should this be all ? */
455: per_assignments_f ass
456: where p.per_information2 = 'Y'
457: and ASS.person_id = P.person_id
458: and P.effective_start_date <= p_end_date
459: and p.effective_end_date >= p_start_date