APPS.HR_DM_GEN_TDS dependencies on HR_DM_HIERARCHIES

Line 475: from hr_dm_hierarchies

471: cursor csr_get_table is
472:
473: select distinct parent_table_id
474: from (select table_id,parent_table_id
475: from hr_dm_hierarchies
476: where hierarchy_type = 'PC')
477: start with table_id = p_table_info.table_id
478: connect by prior parent_table_id = table_id;
479: begin

Line 1554: l_column_name hr_dm_hierarchies.column_name%type;

1550:
1551: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
1552: -- this is to reduce the variable name and add clarity.
1553:
1554: l_column_name hr_dm_hierarchies.column_name%type;
1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

Line 1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;

1551: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
1552: -- this is to reduce the variable name and add clarity.
1553:
1554: l_column_name hr_dm_hierarchies.column_name%type;
1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

Line 1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

1554: l_column_name hr_dm_hierarchies.column_name%type;
1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
1560:
1561:
1562: -- block body of the procedure i.e between begin and end.

Line 1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
1560:
1561:
1562: -- block body of the procedure i.e between begin and end.
1563: l_proc_body varchar2(32767) := null;

Line 1783: from hr_dm_hierarchies h,

1779: l_proc_index number := 1;
1780:
1781: cursor csr_null_hierarchy is
1782: select h.column_name
1783: from hr_dm_hierarchies h,
1784: hr_dm_tables t
1785: where h.hierarchy_type = 'N'
1786: and h.table_id = t.table_id
1787: and t.table_name = upper(p_table_info.table_name);