APPS.OTA_WF dependencies on PER_PEOPLE_F

Line 938: l_email_address per_people_f.email_address%type;

934: l_proc varchar2(72) := g_package||'check_uom';
935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
936: l_order_number oe_order_headers.order_number%type;
937: l_line_number oe_order_lines.line_number%type;
938: l_email_address per_people_f.email_address%type;
939: l_description varchar2(200);
940:
941:
942: CURSOR c_uom IS

Line 956: FROM per_people_f

952: ol.line_id = l_line_id;
953:
954: /*CURSOR c_event IS
955: SELECT email_address
956: FROM per_people_f
957: WHERE person_id IN(
958: select owner_id from
959: ota_events where
960: line_id = l_line_id);*/