DBA Data[Home] [Help]

APPS.AMW_CREATE_LINES_PKG dependencies on AMW_PROC_HIERARCHY_DENORM

Line 133: from amw_proc_hierarchy_denorm d, amw_process_vl a

129: ,a.DISPLAY_NAME
130: ,a.DESCRIPTION
131: ,a.REVISION_NUMBER
132: ,a.approval_status
133: from amw_proc_hierarchy_denorm d, amw_process_vl a
134: where d.process_id = p_pk1 --processId
135: and up_down_ind = 'D'
136: and hierarchy_type = 'L'
137: and a.process_id = d.PARENT_CHILD_ID