eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_UTIL dependencies on PA_PROJECTS_EXPEND_V

Line 10548: --changed the table name from pa_projects_expend_v to

10544: fnd_msg_pub.ADD;
10545: ELSE
10546: BEGIN
10547: --deriving project_number based on project_id
10548: --changed the table name from pa_projects_expend_v to
10549: -- pa_projects_all_expend_v and further changed to pa_task_expend_v
10550: --since we must always have a task_id it does not make sence to check for project_id and task_id
10551: --seperately.The reason we put the rownum 1 is to prevent data corruption issue; if there is data --corruption it should be dealt from the projects side we need not worry about it .
10552:

Line 10555: FROM pa_projects_expend_v pp,

10551: --seperately.The reason we put the rownum 1 is to prevent data corruption issue; if there is data --corruption it should be dealt from the projects side we need not worry about it .
10552:
10553: SELECT pp.project_id, pt.task_id, HOU.organization_id
10554: INTO l_project_id, l_project_task_id, l_exp_org_id
10555: FROM pa_projects_expend_v pp,
10556: pa_tasks_expend_v pt,
10557: pa_organizations_expend_v hou
10558: WHERE pp.project_id = pt.project_id
10559: AND pp.project_id = p_project_id