APPS.PQH_TCT_BUS dependencies on PQH_ROUTING_LISTS

Line 1042: pqh_routing_lists RLT,

1038: --
1039: Cursor csr_routing_name(p_routing_category_id in number) is
1040: Select decode(RCT.routing_list_id,NULL,decode(RCT.position_structure_id,NULL,hr_general.decode_lookup('PQH_SUPERVISORY_HIERARCHY','SUPERVISORY_HIERARCHY'),PPS.name),RLT.routing_list_name) list_name
1041: From pqh_routing_categories RCT ,
1042: pqh_routing_lists RLT,
1043: per_position_structures PPS
1044: WHERE RCT.routing_category_id = p_routing_category_id AND
1045: RCT.routing_list_id = RLT.routing_list_id(+) and
1046: RCT.position_structure_id = PPS.position_structure_id(+);