DBA Data[Home] [Help]

APPS.DPP_APPROVAL_PVT dependencies on PER_ALL_PEOPLE_F

Line 671: FROM per_all_people_f

667: END IF;
668: BEGIN
669: SELECT email_address
670: INTO l_approver_email
671: FROM per_all_people_f
672: WHERE person_id = l_approversOut(i).person_id
673: AND sysdate BETWEEN effective_start_date AND effective_end_date;
674: EXCEPTION
675: WHEN NO_DATA_FOUND THEN