SELECT man_org.Manager_id ,man_org.Manager_Name ,man_res_org.Resource_Organization_id ,pa_expenditures_utils.getorgtlname(man_res_org.Resource_Organization_id) FROM pa_resources_denorm man_org ,pa_resources_denorm man_res_org WHERE man_org.manager_id = man_res_org.Person_id
SELECT MAN_ORG.MANAGER_ID
, MAN_ORG.MANAGER_NAME
, MAN_RES_ORG.RESOURCE_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(MAN_RES_ORG.RESOURCE_ORGANIZATION_ID)
FROM PA_RESOURCES_DENORM MAN_ORG
, PA_RESOURCES_DENORM MAN_RES_ORG
WHERE MAN_ORG.MANAGER_ID = MAN_RES_ORG.PERSON_ID
|
|
|