DBA Data[Home] [Help]

APPS.CS_STD dependencies on PER_ALL_PEOPLE_F

Line 1038: from per_all_people_f where person_id = p_resource_id

1034:
1035: elsif contact_type ='E' then
1036: select email_address
1037: into ret_val
1038: from per_all_people_f where person_id = p_resource_id
1039: and sysdate between effective_start_date and effective_end_date;
1040: end if;
1041: return ret_val;
1042: