DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PJM_SEIBAN_NUMBERS

Line 4477: FROM pjm_seiban_numbers

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
4478: WHERE project_id = x_pjt_id);
4479: EXCEPTION
4480: WHEN No_Data_Found THEN
4481: x_progress := '001';

Line 4598: FROM pjm_seiban_numbers

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
4599: WHERE project_id =x_pjt_id_dummy);
4600: EXCEPTION
4601: WHEN OTHERS THEN
4602: x_progress := '001';

Line 4671: FROM pjm_seiban_numbers

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
4672: WHERE project_id =x_cur_pjt_id);
4673: IF(x_valid_pjt_cnt=0) THEN
4674: SELECT NAME INTO x_cur_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_cur_pjt_id;
4675: IF(x_invalid_pjts Is NULL) THEN