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.POR_UTIL_PKG dependencies on PA_PROJECTS_EXPEND_V

Line 4473: FROM pa_projects_expend_v

4469: if (x_pjt_id IS NOT NULL) THEN
4470: BEGIN
4471: SELECT DISTINCT project_id INTO x_pjt_id_dummy from(
4472: SELECT project_id
4473: FROM pa_projects_expend_v
4474: WHERE project_id = x_pjt_id
4475: UNION ALL
4476: SELECT project_id
4477: FROM pjm_seiban_numbers

Line 4594: FROM pa_projects_expend_v

4590: IF(x_pjt_id_dummy IS NOT NULL) THEN
4591: BEGIN
4592: SELECT Count( DISTINCT project_id) INTO x_valid_pjt_cnt from(
4593: SELECT project_id
4594: FROM pa_projects_expend_v
4595: WHERE project_id = x_pjt_id_dummy
4596: UNION ALL
4597: SELECT project_id
4598: FROM pjm_seiban_numbers

Line 4667: FROM pa_projects_expend_v

4663: IF( x_cur_pjt_id IS NOT NULL) THEN
4664: BEGIN
4665: SELECT Count( DISTINCT project_id) INTO x_valid_pjt_cnt from(
4666: SELECT project_id
4667: FROM pa_projects_expend_v
4668: WHERE project_id = x_cur_pjt_id
4669: UNION ALL
4670: SELECT project_id
4671: FROM pjm_seiban_numbers