APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_LATEST_HIERARCHIES

Line 94: from amw_latest_hierarchies

90: CREATED_BY,
91: object_version_number
92: )
93: (select distinct p_org_id, p_process_id, child_id, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1
94: from amw_latest_hierarchies
95: start with parent_id = p_process_id and organization_id = p_org_id
96: connect by prior child_id = parent_id and organization_id = p_org_id );
97: --ko replacing the below clause...
98: /* (select p_org_id, p_process_id, parent_child_id, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1

Line 138: from amw_latest_hierarchies

134: CREATION_DATE,
135: CREATED_BY,
136: object_version_number
137: )(select distinct p_org_id, p_process_id, child_id, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1
138: from amw_latest_hierarchies
139: start with parent_id = p_process_id and organization_id = p_org_id
140: connect by prior child_id = parent_id and organization_id = p_org_id );
141: --ko replacing the below clause...
142: /* (select p_org_id, p_process_id, parent_child_id, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1

Line 168: from amw_latest_hierarchies

164: curr_app_status varchar2(10);
165:
166: cursor c1 (p_process_id number, p_org_id number) is
167: select distinct child_id parent_child_id
168: from amw_latest_hierarchies
169: start with parent_id = p_process_id and organization_id = p_org_id
170: connect by prior child_id = parent_id and organization_id = p_org_id;
171:
172: cursor c2 (p_process_id number, p_org_id number) is

Line 174: from amw_latest_hierarchies

170: connect by prior child_id = parent_id and organization_id = p_org_id;
171:
172: cursor c2 (p_process_id number, p_org_id number) is
173: select distinct child_id parent_child_id,parent_id
174: from amw_latest_hierarchies
175: start with parent_id = p_process_id and organization_id = (-1*p_org_id)
176: connect by prior child_id = parent_id and organization_id = (-1*p_org_id);
177:
178:

Line 274: delete from amw_latest_hierarchies

270: -- Update the Org Count
271: amw_rl_hierarchy_pkg.update_org_count(c2_rec.parent_child_id);
272: END IF;
273:
274: delete from amw_latest_hierarchies
275: where child_id = c2_rec.parent_child_id
276: and parent_id = c2_rec.parent_id
277: and organization_id = -p_org_id;
278:

Line 378: from amw_latest_hierarchies alh

374: where a.organization_id = p_org_id
375: and a.end_date is null
376: and a.approval_status <> 'A'
377: and a.process_id in ( select alh.child_id
378: from amw_latest_hierarchies alh
379: start with alh.parent_id = p_process_id and alh.organization_id = p_org_id
380: connect by prior alh.child_id = alh.parent_id and alh.organization_id = p_org_id);
381: --ko replacing the below clause...
382: /*

Line 441: from amw_latest_hierarchies alh

437: where a.organization_id = p_org_id
438: and a.end_date is null
439: and a.approval_status <> 'A'
440: and a.process_id in ( select alh.child_id
441: from amw_latest_hierarchies alh
442: start with alh.parent_id = p_process_id and alh.organization_id = p_org_id
443: connect by prior alh.child_id = alh.parent_id and alh.organization_id = p_org_id);
444: --ko replacing the below clause...
445: /*

Line 764: from amw_latest_hierarchies alh

760: p_out_mesg out nocopy varchar2 ) is
761:
762: cursor process_list (pid number, p_org_id number) is
763: select distinct alh.child_id parent_child_id
764: from amw_latest_hierarchies alh
765: start with alh.child_id = p_process_id and alh.organization_id = p_org_id
766: connect by prior alh.child_id = alh.parent_id and alh.organization_id = p_org_id;
767: --ko replacing the below clause...
768: /*

Line 1220: from amw_latest_hierarchies ah

1216: is
1217:
1218: cursor c_all_latest_links_org(l_org_id in number) is
1219: select ah.parent_id , ah.child_id, AH.CHILD_ORDER_NUMBER
1220: from amw_latest_hierarchies ah
1221: where ah.parent_id =(select pp.process_id
1222: from amw_process_organization pp
1223: where pp.organization_id = ah.organization_id
1224: and pp.process_id = ah.parent_id