APPS.PJI_EXTRACTION_UTIL dependencies on PA_PROJECTS_ALL

Line 16: from pa_projects_all prj

12:
13: l_extr_start_date date;
14: Cursor csr_purge_projs is
15: select prj.project_id, sts.project_system_status_code
16: from pa_projects_all prj
17: , pa_project_statuses sts
18: where prj.project_status_code = sts.project_status_code
19: and sts.project_system_status_code in ('PARTIALLY_PURGED'
20: ,'PURGED'

Line 57: -- PA_PROJECTS_ALL. Note that a project cannot be deleted if it has any

53: pji_utils.write2log('WARNING: Global start date has changed.');
54: end if;
55:
56: -- Delete from PJI_PROJ_EXTR_STATUS those projects deleted from
57: -- PA_PROJECTS_ALL. Note that a project cannot be deleted if it has any
58: -- actuals transactions, so we don't need to worry about purging data from
59: -- PJI facts.
60:
61: delete

Line 64: from PA_PROJECTS_ALL pa

60:
61: delete
62: from PJI_PROJ_EXTR_STATUS pji
63: where not exists (select 1
64: from PA_PROJECTS_ALL pa
65: where pa.PROJECT_ID = pji.PROJECT_ID);
66:
67: insert into PJI_PROJ_EXTR_STATUS
68: (

Line 89: PA_PROJECTS_ALL prj,

85: 'CAPITAL', 'C',
86: 'CONTRACT', 'B',
87: 'INDIRECT', 'I')
88: from
89: PA_PROJECTS_ALL prj,
90: PA_PROJECT_STATUSES sts,
91: PA_PROJECT_TYPES_ALL pt,
92: (
93: select

Line 102: PA_PROJECTS_ALL prj

98: parallel_index(prj, PA_PROJECTS_N4) */
99: distinct
100: prj.PROJECT_STATUS_CODE
101: from
102: PA_PROJECTS_ALL prj
103: )
104: where
105: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
106: (PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y'