APPS.ASO_RELATED_OBJ_PVT dependencies on ASO_LOOKUPS

Line 923: from aso_lookups

919: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
920: NULL;
921:
922: select count(*) into l_count
923: from aso_lookups
924: where lookup_type = 'ASO_QUOTE_OBJECT_TYPE'
925: and lookup_code = p_QUOTE_OBJECT_TYPE_CODE;
926:
927: IF l_count < 1 THEN

Line 941: from aso_lookups

937: NULL;
938:
939: IF p_QUOTE_OBJECT_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
940: select count(*) into l_count
941: from aso_lookups
942: where lookup_type = 'ASO_QUOTE_OBJECT_TYPE'
943: and lookup_code = p_QUOTE_OBJECT_TYPE_CODE;
944:
945: IF l_count < 1 THEN

Line 1058: from aso_lookups

1054: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1055: NULL;
1056:
1057: select count(*) into l_count
1058: from aso_lookups
1059: where lookup_type = 'ASO_RELATED_OBJECT_TYPE'
1060: and lookup_code = p_OBJECT_TYPE_CODE;
1061:
1062: IF l_count < 1 THEN

Line 1076: from aso_lookups

1072: NULL;
1073:
1074: IF p_OBJECT_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
1075: select count(*) into l_count
1076: from aso_lookups
1077: where lookup_type = 'ASO_RELATED_OBJECT_TYPE'
1078: and lookup_code = p_OBJECT_TYPE_CODE;
1079:
1080: IF l_count < 1 THEN

Line 1181: from aso_lookups

1177: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1178: NULL;
1179:
1180: SELECT count(*) into l_count
1181: from aso_lookups
1182: where lookup_type = 'ASO_OBJECT_RELATIONSHIP_TYPE'
1183: and lookup_code = p_RELATIONSHIP_TYPE_CODE;
1184:
1185: IF l_count < 1 THEN

Line 1199: from aso_lookups

1195: NULL;
1196:
1197: IF p_RELATIONSHIP_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
1198: SELECT count(*) into l_count
1199: from aso_lookups
1200: where lookup_type = 'ASO_OBJECT_RELATIONSHIP_TYPE'
1201: and lookup_code = p_RELATIONSHIP_TYPE_CODE;
1202:
1203: IF l_count < 1 THEN