APPS.OZF_TP_UTIL_QUERIES dependencies on FND_PROFILE

Line 377: and qp.source_system_code = FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')

373: and act.object_type = p_object_class
374: and act.resource_id= p_resource_id
375: and qp.list_header_id = act.object_id
376: and off.qp_list_header_id = act.object_id
377: and qp.source_system_code = FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')
378: and NVL(off.budget_offer_yn,'N') = 'N';
379: ELSIF p_object_class = 'CSCH' THEN
380: select count(act.object_id) into x_object_count
381: from ams_act_access_denorm act

Line 685: RETURN fnd_profile.value('OZF_TP_QUOTA_ALLOCATION_BY'); --l_quota_unit ;

681: OPEN sys_csr;
682: FETCH sys_csr INTO l_quota_unit;
683: CLOSE sys_csr;
684: */
685: RETURN fnd_profile.value('OZF_TP_QUOTA_ALLOCATION_BY'); --l_quota_unit ;
686:
687: END get_quota_unit;
688:
689: FUNCTION get_item_descr ( p_FlexField_Name IN VARCHAR2

Line 738: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');

734:
735: select description into l_item_name
736: from mtl_system_items_vl
737: where inventory_item_id = p_inventory_item_id
738: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');
739:
740: return l_item_name;
741:
742: END get_item_name;

Line 751: l_item_cost := CST_COST_API.get_item_cost(1,p_inventory_item_id,fnd_profile.value('QP_ORGANIZATION_ID'), NULL,NULL);

747: l_item_cost NUMBER := NULL;
748:
749: BEGIN
750:
751: l_item_cost := CST_COST_API.get_item_cost(1,p_inventory_item_id,fnd_profile.value('QP_ORGANIZATION_ID'), NULL,NULL);
752:
753: return l_item_cost;
754:
755: END get_item_cost;