APPS.PQH_RANKING dependencies on PQH_TABLE_ROUTE

Line 1099: from pqh_table_route_tl trtl,

1095: FUNCTION get_criteria_name (p_tab_short_name in varchar2) RETURN VARCHAR2 IS
1096: --
1097: CURSOR csr_crit_nm IS
1098: select trtl.display_name
1099: from pqh_table_route_tl trtl,
1100: pqh_table_route tr
1101: where trtl.table_route_id = tr.table_route_id
1102: and from_clause = 'OAB'
1103: and language = userenv('lang')

Line 1100: pqh_table_route tr

1096: --
1097: CURSOR csr_crit_nm IS
1098: select trtl.display_name
1099: from pqh_table_route_tl trtl,
1100: pqh_table_route tr
1101: where trtl.table_route_id = tr.table_route_id
1102: and from_clause = 'OAB'
1103: and language = userenv('lang')
1104: and tr.table_alias = p_tab_short_name;

Line 1106: l_crit_name pqh_table_route_tl.display_name%Type;

1102: and from_clause = 'OAB'
1103: and language = userenv('lang')
1104: and tr.table_alias = p_tab_short_name;
1105: --
1106: l_crit_name pqh_table_route_tl.display_name%Type;
1107: --
1108:
1109: l_proc constant varchar2(72):= g_package||'get_criteria_name';
1110: BEGIN