APPS.QP_VALIDATE_FNA dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 132: FROM mtl_default_category_sets

128: -- Check for invalid functional area ID
129: BEGIN
130: SELECT 'VALID'
131: INTO l_valid
132: FROM mtl_default_category_sets
133: WHERE functional_area_id = p_fna_rec.functional_area_id;
134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN
136: l_return_status := FND_API.G_RET_STS_ERROR;

Line 170: from mtl_default_category_sets_fk_v

166: where pte_source_system_id = p_FNA_rec.pte_source_system_id;
167:
168: select functional_area_desc
169: into l_fnarea
170: from mtl_default_category_sets_fk_v
171: where functional_area_id = p_FNA_rec.functional_area_id;
172:
173: FND_MESSAGE.SET_NAME('QP','QP_DUP_FUNC_AREA_WITHIN_PTE');
174: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);

Line 617: from mtl_default_category_sets_fk_v

613: where pte_source_system_id = p_FNA_rec.pte_source_system_id;
614:
615: select functional_area_desc
616: into l_fnarea
617: from mtl_default_category_sets_fk_v
618: where functional_area_id = p_FNA_rec.functional_area_id;
619:
620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
621: THEN