DBA Data[Home] [Help]

APPS.CS_GET_CONTRACTS_PUB dependencies on FND_PROFILE

Line 126: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')

122: BETWEEN SERV.Start_Date_Active AND
123: SERV.End_Date_Active
124: AND SERV.Service_Inventory_Item_Id = MTL.Inventory_Item_Id
125: AND MTL.Organization_Id =
126: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')
127: AND CONT.Contract_Status_Id = STAT.Contract_Status_Id
128: AND STAT.Eligible_for_Entitlements = 'Y';
129:
130:

Line 373: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')

369: BETWEEN SERV.Start_Date_Active AND
370: SERV.End_Date_Active
371: AND SERV.Service_Inventory_Item_Id = MTL.Inventory_Item_Id
372: AND MTL.Organization_Id =
373: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')
374: AND CONT.COntract_Status_Id = STAT.Contract_Status_Id
375: AND STAT.Eligible_for_Entitlements = 'Y';
376:
377: l_covered_Yes_No VARCHAR2(1);

Line 624: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')

620: BETWEEN SERV.Start_Date_Active AND
621: SERV.End_Date_Active
622: AND SERV.Service_Inventory_Item_Id = MTL.Inventory_Item_Id
623: AND MTL.Organization_Id =
624: FND_Profile.Value_Specific('SO_ORGANIZATION_ID')
625: AND CONT.Contract_Status_Id = STAT.Contract_Status_Id
626: AND STAT.Eligible_for_Entitlements = 'Y';
627:
628: l_covered_Yes_No VARCHAR2(1);