DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on PA_OBJ_STATUS_CHANGES

Line 244: FROM pa_obj_status_changes

240: CURSOR l_change_comment_csr(l_project_id NUMBER)
241: IS
242: SELECT change_comment FROM (
243: SELECT change_comment
244: FROM pa_obj_status_changes
245: WHERE object_type = 'PA_PROJECTS'
246: AND object_id = l_project_id
247: AND new_project_status_code =
248: (SELECT project_status_code

Line 297: l_change_comment pa_obj_status_changes.change_comment%TYPE;

293: l_api_version_number NUMBER := 1.0;
294: l_data VARCHAR2(2000);
295: l_msg_index_out NUMBER;
296:
297: l_change_comment pa_obj_status_changes.change_comment%TYPE;
298:
299: --
300: --
301: