APPS.PA_PROJ_STAT_ACTSET dependencies on PA_PROJECTS_ALL

Line 114: ,pa_projects_all p

110: ,p.project_status_code proj_status_code
111: ,l.effective_from effective_from
112: ,l.effective_to effective_to
113: FROM pa_object_page_layouts l
114: ,pa_projects_all p
115: WHERE l.object_page_layout_id = cp_layout_id
116: AND l.object_id = p.project_id;
117:
118: cp_rpt_info c_report_info%ROWTYPE;

Line 121: l_project_id pa_projects_all.project_id%TYPE;

117:
118: cp_rpt_info c_report_info%ROWTYPE;
119:
120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';
121: l_project_id pa_projects_all.project_id%TYPE;
122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;
123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;
124: l_project_status pa_projects_all.project_status_code%TYPE;
125: l_action_performed VARCHAR2(1) := 'N';

Line 124: l_project_status pa_projects_all.project_status_code%TYPE;

120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';
121: l_project_id pa_projects_all.project_id%TYPE;
122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;
123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;
124: l_project_status pa_projects_all.project_status_code%TYPE;
125: l_action_performed VARCHAR2(1) := 'N';
126: l_return_status VARCHAR2(1);
127: l_msg_count NUMBER;
128: l_msg_data fnd_new_messages.message_name%TYPE;