APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_PROCESS_HIERARCHY_V

Line 83: select child_process_id,parent_process_id,parent_process_name,process_name from amw_process_hierarchy_v

79: l_msg_data varchar2(3000) := 'empty';
80:
81: /**
82: cursor c1 is
83: select child_process_id,parent_process_id,parent_process_name,process_name from amw_process_hierarchy_v
84: start with child_process_id=p_process_id
85: connect by prior child_process_id=parent_process_id;
86: **/
87:

Line 90: from amw_process_hierarchy_v

86: **/
87:
88: cursor c1 (l_cpid number) is
89: select parent_process_id,child_process_id,parent_process_name,process_name
90: from amw_process_hierarchy_v
91: where parent_process_id=l_cpid;
92:
93: cursor risk_ctrl is
94: select nvl(risk_count,0) as risk_count,

Line 171: ---select parent_process_id into l_ppid from amw_process_hierarchy_v

167:
168: if(p_level=0)then
169: l_top_process_id := p_process_id;
170:
171: ---select parent_process_id into l_ppid from amw_process_hierarchy_v
172: ---where child_process_id=p_process_id;
173:
174: l_ppid := get_parent_process_id(p_process_id,p_organization_id);
175: ----dbms_output.put_line('l_ppid: '||l_ppid);

Line 2501: from amw_process_hierarchy_v aphv,amw_process_organization apo

2497:
2498:
2499: cursor c1 is
2500: select aphv.parent_process_id,apo.end_date
2501: from amw_process_hierarchy_v aphv,amw_process_organization apo
2502: where aphv.child_process_id=p_process_id
2503: and apo.process_id=p_process_id
2504: and apo.organization_id=p_organization_id;
2505: