APPS.CS_SERVICEREQUEST_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 6526: (select email_address from per_all_people_f per, PER_ALL_ASSIGNMENTS_F Asmt

6522: '+'||hzcp.phone_country_code||' ',null)|| nvl2(hzcp.phone_area_code,'(' ||hzcp.phone_area_code ||')',null)||
6523: hzcp.phone_number ||' ' || nvl2(hzcp.phone_extension, 'x'||hzcp.phone_extension ,null) )
6524: ) ContactPhoneNumber
6525: ,(SELECT CASE when sr_cont.contact_type='EMPLOYEE' then
6526: (select email_address from per_all_people_f per, PER_ALL_ASSIGNMENTS_F Asmt
6527: where per.person_id =sr_cont.party_id
6528: AND Asmt.PERSON_ID = Per.PERSON_ID
6529: AND Asmt.PRIMARY_FLAG = 'Y'
6530: AND Asmt.ASSIGNMENT_TYPE in ( 'E', 'C')

Line 6535: FROM PER_ALL_ASSIGNMENTS_F b

6531: AND Per.EFFECTIVE_START_DATE = (SELECT MAX(q.EFFECTIVE_START_DATE)
6532: FROM PER_ALL_PEOPLE_F q
6533: WHERE q.person_id = per.person_id)
6534: AND Asmt.EFFECTIVE_START_DATE= (SELECT MAX(b.EFFECTIVE_START_DATE)
6535: FROM PER_ALL_ASSIGNMENTS_F b
6536: WHERE b.person_id = Asmt.person_id
6537: AND b.assignment_id = Asmt.assignment_id) and rownum=1)
6538: ELSE hzcp.email_address END AS ContactEmail from dual) ContactEmail
6539: ,(SELECT cat.concatenated_segments