APPS.AMW_CREATE_LINES_PKG dependencies on AMW_CURR_APP_HIERARCHY_RL_V

Line 141: from AMW_curr_app_HIERARCHY_rl_V

137: and a.process_id = d.PARENT_CHILD_ID
138: and a.end_date is null
139: and a.approval_status <> 'A'
140: and a.process_id in (select child_process_id
141: from AMW_curr_app_HIERARCHY_rl_V
142: where parent_process_id=p_pk1);
143:
144: ---02.15.2004 npanandi: cursor to get processes for AddProcess lineType
145: ---only 1 level below i.e. immediate child processes

Line 165: ,AMW_CURR_APP_HIERARCHY_RL_V APHD

161: ,ALR.DESCRIPTION
162: ,ALR.PROCESS_CODE
163: --,alr.revision_number
164: FROM AMW_LATEST_REVISIONS_V ALR
165: ,AMW_CURR_APP_HIERARCHY_RL_V APHD
166: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
167: AND APHD.parent_PROCESS_ID=p_pk1; --processId
168:
169: ---02.15.2004 npanandi: cursor to get processes for DeleteProcess lineType

Line 179: ,AMW_CURR_APP_HIERARCHY_RL_V APHD

175: ,ALR.DESCRIPTION
176: ,ALR.PROCESS_CODE
177: --,alr.revision_number
178: FROM AMW_LATEST_REVISIONS_V ALR
179: ,AMW_CURR_APP_HIERARCHY_RL_V APHD
180: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
181: AND APHD.parent_PROCESS_ID=p_pk1 --processId
182: minus
183: SELECT ALR.PROCESS_ID

Line 476: from amw_curr_app_hierarchy_rl_v

472: ---there may be an immediate child Process, which is also in Draft status
473: ---in this case, the DeleteProcess Cursor's 'minus' clause causes problems in
474: ---revisionNumber data, and incorrect resultSet is obtained.
475: select child_revision_number into l_revision_number
476: from amw_curr_app_hierarchy_rl_v
477: where parent_process_id=p_pk1 --parentProcessId
478: and child_process_id=delete_proc_rec.process_id; --childProcessId
479:
480: process_lines(