APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 3328: FROM pji_pa_proj_events_log LOG,

3324: IS
3325: SELECT 1
3326: FROM dual
3327: WHERE EXISTS (SELECT LOG.event_id
3328: FROM pji_pa_proj_events_log LOG,
3329: pa_proj_element_versions ver
3330: WHERE LOG.event_type='PRG_CHANGE'
3331: AND LOG.event_object =TO_CHAR(ver.prg_group)
3332: 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 5129: from pji_pa_proj_events_log log,pa_proj_element_versions ver

5125: CURSOR c1 IS
5126: select 1
5127: from dual
5128: where exists (select log.event_id
5129: from pji_pa_proj_events_log log,pa_proj_element_versions ver
5130: where log.event_type='PRG_CHANGE'
5131: and log.event_object =to_char(ver.prg_group)
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

Line 5225: from pji_pa_proj_events_log log

5221: CURSOR c1 IS
5222: select 1
5223: from dual
5224: where exists (select log.event_id
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