DBA Data[Home] [Help]

APPS.PQH_TCT_BUS dependencies on HR_GENERAL

Line 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

1036: --
1037: -- The foll cursor returns the name of the routing category.
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