APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 3335: FROM pa_pji_proj_events_log LOG,

3331: AND LOG.event_object =TO_CHAR(ver.prg_group)
3332: AND ver.project_id=p_project_id
3333: UNION ALL
3334: SELECT LOG.event_id
3335: FROM pa_pji_proj_events_log LOG,
3336: pa_proj_element_versions ver
3337: WHERE LOG.event_type='PRG_CHANGE'
3338: AND LOG.event_object =TO_CHAR(ver.prg_group)
3339: AND ver.project_id=p_project_id);

Line 5111: -- log type PRG_CHANGE in the pa_pji_proj_events_log, pji_pa_proj_events_log tables.

5107: -- API name : check_pending_link_changes
5108: -- Type : Utils API
5109: -- Pre-reqs : None
5110: -- Return Value : This API returns "Y" if pending link changes exist for a given project as per
5111: -- log type PRG_CHANGE in the pa_pji_proj_events_log, pji_pa_proj_events_log tables.
5112: -- It's created to use from Projects Self Services (sql from vijay r).
5113: --
5114: -- Parameters
5115: -- p_project_id IN NUMBER

Line 5136: from pa_pji_proj_events_log log,pa_proj_element_versions ver

5132: and ver.project_id=p_project_id
5133: and ver.parent_structure_version_id = nvl(p_version_id,ver.parent_structure_version_id) --Bug#8889029.added nvl
5134: union all
5135: select log.event_id
5136: from pa_pji_proj_events_log log,pa_proj_element_versions ver
5137: where log.event_type='PRG_CHANGE'
5138: and log.event_object =to_char(ver.prg_group)
5139: and ver.project_id=p_project_id
5140: and ver.parent_structure_version_id = nvl(p_version_id,ver.parent_structure_version_id) --Bug#8889029.added nvl

Line 5229: from pa_pji_proj_events_log log

5225: from pji_pa_proj_events_log log
5226: where log.event_type='PRG_CHANGE'
5227: union all
5228: select log.event_id
5229: from pa_pji_proj_events_log log
5230: where log.event_type='PRG_CHANGE'
5231: );
5232:
5233: l_dummy VARCHAR2(1);