[Home] [Help]
APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on PER_WORKFORCE_X
Line 1532: FROM per_workforce_x
1528: ) RETURN VARCHAR2 as
1529:
1530: cursor get_emp_name is
1531: SELECT first_name || ' ' ||last_name
1532: FROM per_workforce_x
1533: WHERE person_id = p_person_id;
1534:
1535: l_emp_contact_name varchar2(360);
1536:
Line 1562: FROM per_workforce_x
1558: ) RETURN VARCHAR2 as
1559:
1560: cursor get_emp_email is
1561: SELECT email_address
1562: FROM per_workforce_x
1563: WHERE person_id = p_person_id;
1564:
1565: l_emp_contact_email varchar2(250);
1566: