APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on PA_OBJ_STATUS_CHANGES

Line 651: from pa_obj_status_changes

647: select a.old_project_status_code, a.new_project_status_code
648: from (select obj_status_change_id,
649: old_project_status_code,
650: new_project_status_code
651: from pa_obj_status_changes
652: where object_type = 'PA_CI_TYPES'
653: and object_id = p_ci_id
654: order by obj_status_change_id desc) a
655: where rownum = 1;

Line 657: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;

653: and object_id = p_ci_id
654: order by obj_status_change_id desc) a
655: where rownum = 1;
656:
657: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
658: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
659: l_comment pa_ci_comments.comment_text%TYPE;
660: -- Bug 6843085
661:

Line 658: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

654: order by obj_status_change_id desc) a
655: where rownum = 1;
656:
657: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
658: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
659: l_comment pa_ci_comments.comment_text%TYPE;
660: -- Bug 6843085
661:
662: display_name VARCHAR2(2000);