APPS.QP_CATEGORY_MAPPING_RULE dependencies on FND_GLOBAL

Line 112: l_appl_id := FND_GLOBAL.RESP_APPL_ID;

108: and FNAREA.ENABLED_FLAG = 'Y');
109:
110: BEGIN
111:
112: l_appl_id := FND_GLOBAL.RESP_APPL_ID;
113:
114: IF QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE = 'ONT' THEN
115: --passing null org_id to OE_Sys_Parameters for moac so that it will return MASTER_ORGANIZATION_ID
116: --for the org_context set -- build_contexts API or calling app would have set 'single' org context

Line 295: and sets.functional_area_id = decode(FND_GLOBAL.RESP_APPL_ID, 201,

291: and mtl.category_set_id = l_category_set_id
292: and eni.object_type = 'CATEGORY_SET'
293: and eni.object_id = sets.category_set_id
294: and mtl.category_id = eni.child_id
295: and sets.functional_area_id = decode(FND_GLOBAL.RESP_APPL_ID, 201,
296: 2, 11)
297: and (mtl.organization_id = p_org_id or p_org_id IS NULL)
298: and eni.parent_id = p_category_id)
299: and rownum=1;