APPS.HR_DM_IMP_BG_WHERE dependencies on HR_DM_HIERARCHIES

Line 84: from hr_dm_hierarchies

80: column_name,
81: parent_table_id,
82: parent_column_name,
83: 'N' logical_delete
84: from hr_dm_hierarchies
85: where hierarchy_type = 'PC')
86: start with table_id = p_table_info.table_id
87: connect by prior parent_table_id = table_id
88: order by level desc;

Line 848: -- hr_dm_hierarchies table is used to derive the 'where' clause.

844: -------------------------------------------------------------------------
845: -- Main Procedure
846: -- This function creates the where clause for the table which do not have
847: -- business group id but the parent tables relationship is stored in
848: -- hr_dm_hierarchies table is used to derive the 'where' clause.
849: -- Input Parameter :
850: -- p_cursor_type - The cursor for which where clause needs to be formed.
851: -- It can have following values :
852: -- 'DOWNLOAD' - where clause for download procedure