APPS.AHL_COMPLETIONS_PVT dependencies on FND_PROFILE

Line 47: G_CTR_READING_PLAN_ID NUMBER := FND_PROFILE.value ( 'AHL_WO_CTR_READING_PLAN' );

43: -- Visit Statuses
44: G_VISIT_STATUS_RELEASED VARCHAR2(30) := 'RELEASED'; --Released
45:
46: -- Counter Reading Plan
47: G_CTR_READING_PLAN_ID NUMBER := FND_PROFILE.value ( 'AHL_WO_CTR_READING_PLAN' );
48:
49: cursor is_qa_coll_reqd(p_plan_id IN NUMBER) IS
50: select 'x' from qa_plan_transactions_v
51: where mandatory_collection_flag = 1 and enabled_flag = 1