APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_SOURCESYSTEM_FNAREA_MAP

Line 77: QP_SOURCESYSTEM_FNAREA_MAP FNAREA

73: AND nvl(d.hierarchy_enabled,'N') = 'N'
74: AND c.functional_area_id in (SELECT distinct FNAREA.FUNCTIONAL_AREA_ID
75: FROM QP_PTE_REQUEST_TYPES_B REQ,
76: QP_PTE_SOURCE_SYSTEMS SOU,
77: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
78: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in and REQ.ENABLED_FLAG = 'Y' and
79: REQ.PTE_CODE = SOU.PTE_CODE and SOU.ENABLED_FLAG = 'Y'and
80: SOU.PTE_SOURCE_SYSTEM_ID = FNAREA.PTE_SOURCE_SYSTEM_ID and
81: FNAREA.ENABLED_FLAG = 'Y');

Line 101: QP_SOURCESYSTEM_FNAREA_MAP FNAREA

97: c.functional_area_id in (SELECT /*+ ORDERED USE_NL(REQ SOU FNAREA)*/
98: distinct FNAREA.FUNCTIONAL_AREA_ID
99: FROM QP_PTE_REQUEST_TYPES_B REQ,
100: QP_PTE_SOURCE_SYSTEMS SOU,
101: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
102: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in
103: and REQ.ENABLED_FLAG = 'Y'
104: and REQ.PTE_CODE = SOU.PTE_CODE
105: and SOU.ENABLED_FLAG = 'Y'