APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on PA_OBJ_STATUS_CHANGES

Line 656: from pa_obj_status_changes

652: select a.old_project_status_code, a.new_project_status_code
653: from (select obj_status_change_id,
654: old_project_status_code,
655: new_project_status_code
656: from pa_obj_status_changes
657: where object_type = 'PA_CI_TYPES'
658: and object_id = p_ci_id
659: order by obj_status_change_id desc) a
660: where rownum = 1;

Line 662: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;

658: and object_id = p_ci_id
659: order by obj_status_change_id desc) a
660: where rownum = 1;
661:
662: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
663: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
664: l_comment pa_ci_comments.comment_text%TYPE;
665: -- Bug 6843085
666:

Line 663: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

659: order by obj_status_change_id desc) a
660: where rownum = 1;
661:
662: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
663: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
664: l_comment pa_ci_comments.comment_text%TYPE;
665: -- Bug 6843085
666:
667: display_name VARCHAR2(2000);