APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PROJ_REFRESH_TMP

Line 2161: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))

2157: AND (
2158: (
2159: ( ppr.segment1 BETWEEN l_project_num_from AND l_project_num_to) AND l_client_extn_mode = 'N' )
2160: OR
2161: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))
2162: ) --14090312
2163: AND ppr.project_type = NVL(x_project_type, project_type) -- for bug 2543021
2164: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N';
2165:

Line 2189: delete from PA_PROJ_REFRESH_TMP; --14090312

2185:
2186: x_summ_process := 'RF';
2187: x_err_stage := 'Project refresh Process';
2188: x_log_summ_mode := Fnd_Profile.value('PA_LOG_SUMM_MODE');
2189: delete from PA_PROJ_REFRESH_TMP; --14090312
2190: IF (x_end_date_through IS NULL OR x_end_date_through >= x_current_pa_end_date) THEN
2191: x_date_through := x_end_pa_date;
2192: ELSE
2193: x_date_through := x_end_date_through;

Line 2224: insert into PA_PROJ_REFRESH_TMP (project_id) values (tmp_table(i));

2220: then
2221:
2222: pa_client_extn_proj_limit.populate_project_id_list(tmp_table);
2223: for i in 1..tmp_table.count loop
2224: insert into PA_PROJ_REFRESH_TMP (project_id) values (tmp_table(i));
2225: end loop;
2226: else
2227:
2228: l_client_extn_mode:='N';

Line 3930: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=pfa.project_id))

3926: FROM pa_projects_for_accum pfa
3927: WHERE pfa.request_id = x_request_id
3928: AND (
3929: ((pfa.segment1 BETWEEN p_project_num_from AND p_project_num_to) and l_client_extn_mode='N') OR
3930: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=pfa.project_id))
3931: ) --14090312
3932: AND pfa.action_flag = 'CM'
3933: AND NOT EXISTS (SELECT pf.project_id
3934: FROM pa_projects_for_accum pf

Line 3947: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))

3943: FROM pa_projects ppr
3944: WHERE NVL(ppr.template_flag,'N') <> 'Y'
3945: AND (
3946: ((ppr.segment1 BETWEEN p_project_num_from AND p_project_num_to) and l_client_extn_mode='N') OR
3947: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))
3948: ) --14090312
3949: AND ppr.project_type = NVL(p_project_type, project_type)
3950: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N');
3951: END IF;